Section 15.2. Tools


15.2. Tools

SQL Server 2005 provides the following tools for designing and managing Integration Services:


Business Intelligence Development Studio

Helps to develop, test, debug, and deploy integration packages.


SQL Server 2005 Management Studio

Manages packages in production.


SSIS Designer

A graphical tool in Business Intelligence Development Studio that is used to construct control flows and data flows in packages, add event handlers to the packages and package objects, view package contents, and view execution progress of packages.


Integration Services Wizards

Wizards for copying data between data sources, constructing simple packages, creating package configurations, deploying Integration Services projects, and migrating SQL Server 2000 DTS packages.


Command-line utilities

Tools to manage packages, specify package runtime configuration, and run packages from the command line, as described in Table 15-7.

Table 15-7. SSIS command-line utilities

Command-line utility

Description

dtexecui

Specifies runtime configuration and runs an existing package on the local computer

dtexec

Configures and runs an existing package stored in a SQL Server database, the SSIS package store, and the filesystem

dtutil

Manages, copies, deletes, moves, and verifies the existence of existing packages stored in a SQL Server database, the SSIS package store, and the filesystem




Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net