1 / 35

SSIS 2012: Enhanced Features and Tools for Efficient Data Management

Explore SSIS 2012 with Scott Simon, detailing new interface, toolbox, connections, and improvements in control flow and data flow. Learn about debugging, deploying, and executing packages. Find resources, demos, and key functionalities.

fadhila
Download Presentation

SSIS 2012: Enhanced Features and Tools for Efficient Data Management

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. Dayton Web DevelpersScott Simon, MCTS SQL Server Integration Services September 2012

  2. SSIS 2012Agenda • Resources – Databases, Samples, Toolkit, Blogs, Books • Project Conversion Demo • New Features, Interface Changes, Toolbox, Connections • Improvements to Control Flow & Data Flow • Debug, Deploy, and Execute Package

  3. SSIS 2012Definition and Resources Sample Databases Books Online SQL Server Journey with SQL Authority Developer Toolkit

  4. SSIS 2012DEMO

  5. SSIS 2012DEMO

  6. SSIS 2012New Features • (BIDS) is now a Microsoft Visual Studio 2010 shell called SQL Server Data Tools (SSDT) • New Project Options:

  7. SSIS 2012Interface Changes

  8. SSIS 2012Interface Explained

  9. SSIS 2012Toolbox Control Flow Data Flow

  10. SSIS 2012Connections Shared Connection Managers Scripting Engine database.

  11. SSIS 2012Expressions Expression Indicators • Flexibility • Dynamically change connection strings • A visual cue that the connection manager uses an expression

  12. SSIS 2012Features Features • Undo and Redo • Package Sort By Name • Status Indicators

  13. SSIS 2012Control Flows Control Flow • Expression Task • Execute Package Task

  14. SSIS 2012Data Flows Data Flow • Sources and Destination Assistants • ODBC Source and Destination • Flat File Source • Variable Columns • Embedded Qualifiers

  15. SSIS 2012Column References Column References • Columns

  16. SSIS 2012Collapsible Grouping • Grouping

  17. SSIS 2012Data Viewer • Viewer

  18. SSIS 2012Flexible Package Design • Variables • Expressions • Functions

  19. SSIS 2012Deployment Models • Deployment Model Comparison

  20. SSIS 2012Deployment Models • Deployment Model Features • Project Deployment Workflow • Deploy

  21. SSIS 2012Deployment Models • Import • Convert

  22. SSIS 2012Parameters • Project • Package

  23. SSIS 2012Parameters • Server Default Values • Execution Parameter Values

  24. SSIS 2012Integration Services Catalog • Managing and Monitoring SSIS Projects Using the SSIS Catalog • Step 2 • Catalog Creation • Catalog Properties

  25. SSIS 2012Integration Services Catalog • Encryption • Operations • Project Versioning

  26. SSIS 2012Environment Objects • Environments • Environment Variables • Environment References

  27. SSIS 2012Administration • Validation • Package Execution

  28. SSIS 2012Logging and Troubleshooting Tools • Package Execution Logs • Data Taps • Reports

  29. SSIS 2012Security and File Format • Security • Package File Format

  30. SSIS 2012Environment Cleanup

  31. SSIS 2012Change Data Capture • CDC

  32. SSIS 2012Change Data Capture • CDC

  33. SSIS 2012 TrainingLeap Readiness

  34. SSIS 2012Summary • Resources – Databases, Samples, Toolkit, Blogs, Books • Project Conversion Demo • New Features, Interface Changes, Toolbox, Connections • Improvements to Control Flow & Data Flow • Debug, Deploy, and Execute Package

  35. Questions & Feedback Scott Simon Manager Consultant scott.simon@us.sogeti.com

More Related