O'Reilly logo

Microsoft® SQL Server 2008 R2 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul 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

SSIS Tools and Utilities

SSIS includes several tools that simplify package creation, execution, and management. These tools are available within the Visual Studio/BI Development Studio IDE (as shown in the drop-down list in Figure 52.7) or integrated into other component-based tools (such as SSMS, as shown in Figure 52.8).

Figure 52.7 Package creation options within Visual Studio/BI Development Studio.

image

Figure 52.8 Invoking SSIS import/export data (package creation) capability from within SSMS.

image

Equally as easily, you can invoke SSIS functionality ...

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