1 / 18

What’s Coming Next in SSIS

Explore the enhanced usability, configuration, deployment, and operational management features in SQL Server Denali for enterprise data integration. Learn about the new UI redesign, undo projects, flexible order of authoring, and more.

lukej
Download Presentation

What’s Coming Next in SSIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. Enterprise Data Integration & Management

  3. Integration Services in SQL Server Denali Enhanced Usability Configuration, Deployment, Operational Mgmt UI redesign:targeted at new users / adoption Key customer asks such as Undo Projects collect related packages New SSIS Server Full lifecycle support: develop, deploy, manage projects Enhanced monitoring, debugging

  4. Overview

  5. Demo Developer Experience

  6. 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, butit will be upgraded by RTM

  7. Introducing… Configuration & Deployment

  8. Projects & Parameters Sales HR HR DW project SAP migration project Projects Groups of packages (anywhere) <xml> x\y\MyTask\Server = “TestServer” ServerName is String BatchNumber is Int32 HR DW project x y Configurations Parameters

  9. Demo Projects & Parameters

  10. What Did I Just See? • Bundling of packages • New configuration model • Migration Wizard

  11. The SSIS Server IS 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 SSMS BIDS Management experience Dashboards MOM Support Powershell support Create parameters for package and projects Switch between different deployment models Compile packages to single Deployment File

  12. IS Server as a SQL Application Powershell SSMS Deployment Wizard Application Manage Manage Manage Project Manage Project IS Server Execution Process SQL Server Instance Execution Control Deploy Manage Security Validate Execute IS Objects Operation logs Runtime Security State Components IS Catalog

  13. Making Things Better for the DBA • SSMS and Powershell integration • Centralized management • More control over logging

  14. Demo Server Deployment

  15. What Did I Just See? • SSMS based management experience • Central deployment and management • Enhanced server logging

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

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

  18. Thank you for attending this session andSQLBits 8 in Brighton

More Related