Key takeaways:
- SSIS logging and auditing in SQL Server Denali
- Deploying packages in Denali
- Parameterization of packages
Level 200
60-75 minutes
In this session, you’ll learn how to manage SSIS in SQL Server Denali. You’ll first see how the logging and auditing of your SSIS packages has changed in Denali. Then, you’ll learn how parameterization of packages has been overhauled in Denali to make a zero-touch deployment of your packages. In this demo-packed session, you’ll walk through the entire lifecycle of a package from deployment to longer-term management of the package.
Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at SQLShare.com. He is the author of a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog
can be found at http://www.bidn.com.