September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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.

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

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