O'Reilly logo

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step by Solid Quality Learning

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

Using SSIS to Transfer Your Data

Of all the methods for transferring databases, SQL Server Integration Services (SSIS) is the most flexible and robust. Not only can it transfer data, it can transform it. While this transformation capability is quite useful, it is not within the scope of this book. We will consider only the various options available in SSIS for moving data from your source system to your target system; we will not discuss any of the sophisticated data transformations that are possible with SSIS.

While the previously described methods required you to spend time in SQL Server Management Studio, in order to use SQL Server Integration Services, you will need to work in the Visual Studio 2005 IDE (Integrated Development Environment). ...

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