Whats Coming Next in SSIS SQL Server Denali

What’s Coming Next in SSIS SQL Server Denali CTP 1 Jamie Thomson

Enterprise Data Integration & Management Integration Services Data Quality Services EDIM Master Data Services BIA 380 M • What’s Coming Next in SSIS Impact Analysis and Lineage

Integration Services in SQL Server Denali Enhanced Usability BIA 380 M • What’s Coming Next in SSIS Configuration, Deployment, Operational Mgmt

Overview • Designer Changes • Configuration & Deployment • SSIS Server Management BIA 380 M • What’s Coming Next in SSIS

Demo DEVELOPER EXPERIENCE

What Did I Just See? Designer Improvements – “The Ramp” • • • UI changes Undo support Custom Toolbox Connection Assistant Flexible Order of Authoring In the current CTP, BIDS is still VS 2008, but it will be upgraded by RTM

Introducing… CONFIGURATION &DEPLOYMENT EPLOYMEN

Projects & Parameters Sales HR HR DW project SAP migration project Groups of packages (anywhere) <xml> xyMy. TaskServer = “Test. Server” Projects Server. Name is String HR DW project x y Configurations Parameters Batch. Number is Int 32

Demo PROJECTS &PARAMETERS

What Did I Just See? Bundling of packages New configuration model Migration Wizard BIA 380 M • What’s Coming Next in SSIS

The SSIS Server and Engine Tools and Components Deployment of projects Folders and Environment Enhanced logging capabilities Support for parameters in Runtime OM and Server Migration Wizard Deployment Wizard Improvements to existing Execute Package Task (EPT) Improve the deployment and management experience for SSIS Packages BIDS Create parameters for package and projects Switch between different deployment models Compile packages to single Deployment File BIA 380 M • What’s Coming Next in SSIS SSMS Management experience Dashboards MOM Support Powershell support

IS Server as a SQL Application Powershell SSMS Manage Deployment Wizard Manage Project SQL Server Instance IS Server Deploy Manage Security Validate IS Objects Operation logs Security State Execute Manage Project Execution Process Execution Control Runtime Components IS Catalog BIA 380 M • What’s Coming Next in SSIS Application

Making Things Better for the DBA SSMS and Powershell integration Centralized management More control over logging BIA 380 M • What’s Coming Next in SSIS

Demo SERVER DEPLOYMENT

What Did I Just See? SSMS based management experience Central deployment and management Enhanced server logging BIA 380 M • What’s Coming Next in SSIS

What’s in CTP 1 Project & Parameter model IS Server Designer • • • Undo Design surface changes Improved Toolbox Flexible Order of Authoring Source and Destination assistants

What’s Coming Data Quality Services SQL Agent integration for server execution Troubleshooting and logging improvements Dependency Analysis extensions Package format changes … … and of course, quality improvements

Thank you for attending this session and SQLBits 8 in Brighton