Discover the hidden gems of SQL Server Integration Services (SSIS) in the "Denali" release through this comprehensive conference talk. Explore beyond the well-known major improvements like enhanced Developer Experience, Project & Parameter model, and new Server-based deployment features. Delve into hundreds of customer-reported Connect issues that have been resolved, making this the highest quality release to date. Learn about the SSIS Catalog, CDC Service, artifacts, tools, and goals. Gain insights into Connection Managers and Flat File Improvements through demonstrations. Understand the new Designer Configuration, Parameter UI, and Troubleshooting Logging features. Explore data taps, binary data handling, and Server Management capabilities. Get hands-on with PowerShell for creating catalogs and running packages. Analyze performance breakdowns and interact with the Execution UI. This talk covers a wide range of topics, ensuring you'll uncover valuable information to enhance your SSIS experience in SQL Server "Denali." Read more