Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"

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."

Introduction
Projects and Parameters
SSIS Catalog
CDC Service
CDC artifacts
CDC tools
CDC goal
Connection Managers
Flat File Improvements
Demo
New Designer
Configuration
Parameter UI
Demos
Troubleshooting Logging
Data taps
Binary data
Server Management
PowerShell
Create Catalog
Running a Package
Performance Breakdown
Interactive Execution UI
Clean Up Before I Forget