O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

It is fairly easy to create and implement a typical data export, data import, or complex data transformation by using SSIS. You can either use the wizard for basic data transformation needs or the SSIS Designer for massively complex transformations (which may have multiple data sources and/or multiple dvata destinations). This very robust environment has adopted a very formal, managed code rigor. With the SSIS capabilities, you get a self-contained place to build these data transformation solutions, and you can do so very rapidly. SSIS is completely integrated into the Visual Studio environment as well, making it that much easier to start producing rock-solid implementations. And with Change Data Capture for SSIS, a new dimension of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required