1 / 20

SSIS Changes in Denali: A Deep Dive

Explore the evolution of SQL Server Integration Services (SSIS) in Denali, uncovering new features, improvements, and enhancements for database management and ETL processes. From variable management to cluster awareness, discover the latest updates.

kiele
Download Presentation

SSIS Changes in Denali: A Deep Dive

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. SSIS Changes in Denali Phil Brammer

  2. Phil Brammer • Over 10 years’ experience in database technologies, data warehousing, ETL, on-call… • Started on Red Brick Data Warehouse. Ralph Kimball’s product. Inmon Who? • Worked with Teradata at PayPal • Operationally manages multi-terabyte instances • Dabbles a bit in SSIS – ssistalk.com • Microsoft MVP, SQL Server – 5th year

  3. Denali • Code name • Yukon, Katmai, Kilimanjaro • CTP 3 • microsoft.com/sql/

  4. SSIS • Born in 2005 as a replacement for DTS • Groans or applause? • Client focused

  5. SSIS in Denali • Server Focused! • Minimal, but juicy changes in the client • Cluster aware. Sort of. • DTS is no longer supported. • BIDS changes!

  6. Getting Started • A new window with links to samples and videos. • Demo

  7. Undo / Redo • CTRL-Z / CTRL-Y • Toolbar buttons • Demo

  8. Expression Indicators • Variables and Connection Managers • A welcome addition; currently found in BIDS Helper. http://bidshelper.codeplex.com/ • The next release (after CTP3) will also show expressions on tasks. • Demo

  9. Expressions • No 4,000 character limit! • LEFT() function • TOKEN() function • TOKENCOUNT() function • Demo

  10. Expression Task • You can now assign a value to a variable in the control flow! • Good for initializing a variable in a loop • Simplifies variable management • Demo

  11. Variables • Default to package scope, no matter where they are created. • Can now be moved to different scopes! • Demo

  12. Execution status indicators • Primarily for accessibility (disability) support • Creates a more refined look • Demo

  13. Data Viewer • Now a simplified UI • Demo

  14. Row Count Component • New UI! Just select a variable.

  15. Projects • Packages are now part of a project • A server feature • Can share connections • Can share parameters • .ispac file (really just a .zip file) • Demo

  16. Parameters • Project level – deployed across all packages within a project • Package level – specific to a single package • Demo

  17. Deployment • Deploy from BIDS • Will deploy all packages in a project • Demo

  18. Environments • Chosen at run time, contains a set of parameters. • Useful for creating one package and allowing for different environments/requirements • Demo

  19. Logging • Captures logs by default • Reporting infrastructure by default • Many troubleshooting resources • Demo

  20. Data Taps • A SQL-based data viewer • No need to open up package • Insert data tap to investigate issues • Can only store files in <SQLInstallDir>\110\DTS\DataDumps • Demo

More Related