Integration Services Tools and Utilities

This section describes how to use Business Intelligence Development Studio and SQL Server Management Studio with Microsoft SQL Server 2005 Integration Services (SSIS) and the tools and utilities that Integration Services provides.

The following table describes the topics covered in this section.

Topic Description

Integration Services and Studio Environments

Describes how to use Business Intelligence Development Studio and SQL Server Management Studio with Integration Services.

SSIS Designer

Describes the graphical tool for building complex packages that include control flows, data flows, and event-driven logic.

Integration Services Wizards

Describes the wizards for importing and exporting data, installing packages, migrating packages, and creating package configurations.

Command Prompt Utilities (SSIS)

Describes the Integration Services command prompt utilities for managing and running packages.

Query Builder (SSIS)

Describes the graphical tool for building queries.

Expression Builder (SSIS)

Describes the graphical tool for building expressions.

See Also

Concepts

Typical Uses of Integration Services
Integration Services Architecture
Integration Services Overview
SQL Server Integration Services

Other Resources

Integration Services Objects and Concepts

Help and Information

Getting SQL Server 2005 Assistance