1 / 29

BIN303 What’s Coming Next In SSIS?

BIN303 What’s Coming Next In SSIS?. Steve Swartz SSIS Group Program Manager Microsoft Corporation. Enterprise Information Management. What’s Coming in Integration Services?. Enhanced Usability . Dependency Analysis. Configuration, Deployment, Operational Mgmt.

powa
Download Presentation

BIN303 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. BIN303What’s Coming Next In SSIS? Steve Swartz SSIS Group Program Manager Microsoft Corporation

  2. Enterprise Information Management

  3. What’s Coming in Integration Services? Enhanced Usability Dependency Analysis Configuration, Deployment, Operational Mgmt Foundational layer to track impact/lineage across SQL platform 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. Designer Changes

  6. Developer Experience demo

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

  8. Configuration & Deployment

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

  10. Projects & Parameters demo

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

  12. The SSIS Server

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

  14. IS Server as a SQL Application Powershell SSMS Deployment Wizard Application OM: Manage OM: Manage OM: Manage OM: Project OM: Manage OM: 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

  15. Making Things Better for the DBA • SSMS and Powershell integration • Centralized management • Row level security • More control over logging

  16. Server Deployment demo

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

  18. Dependency Analysis

  19. IT Pro Scenario SSAS SAP SSRS My DW SSIS

  20. IW Scenario SSAS SSRS SAP

  21. Architecture Check Dependencies Application Artifacts Metadata Extractors Dependency Extraction Custom Queries Load Metadata SQL Server

  22. VSTS Migration

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

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

  25. Session Evaluations Tell us what you think, and you could win! All evaluations submitted are automatically entered into a daily prize draw*  Sign-in to the Schedule Builder at http://europe.msteched.com/topic/list/ * Details of prize draw rules can be obtained from the Information Desk.

  26. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related