Jaa


Integration Services How-to Topics

This section contains procedures that describe how to use the tools provided in Microsoft SQL Server 2005 Integration Services (SSIS) to create, modify, extend, and deploy packages and the data sources and data source views that packages use.

The topics are grouped by subject area, and cover both the features and functions in Business Intelligence Development Studio, and the various objects and features in Integration Services.

The following table lists the How To topics covered in this section.

Topic Description

Solutions and Projects How-to Topics (SSIS)

Contains procedures for working with solutions and projects in Business Intelligence Development Studio.

Package How-to Topics (SSIS)

Contains procedures for creating, modifying, and deleting packages; for importing and exporting packages to and from SQL Server Management Studio; and for extending package functionality.

Control Flow How-to Topics (SSIS)

Contains procedures for adding, configuring, modifying, and deleting control flow elements and creating control flows in packages.

Data Flow How-to Topics (SSIS)

Contains procedures for creating data flows in packages, and for adding, configuring, modifying, and deleting data flow elements.

Event Handler How-to Topics (SSIS)

Contains procedures for creating event handlers for Integration Services events.

Connection Manager How-to Topics (SSIS)

Contains procedures for adding, configuring, modifying, and deleting connection managers.

Deployment How-to Topics (SSIS)

Contains procedures for creating package configurations, for building a deployment utility for an Integration Services project, and for deploying packages.

Security How-to Topics (SSIS)

Contains procedures for implementing the package security features that Integration Services provides.

Variables How-to Topics (SSIS)

Contains procedures for creating, modifying, and deleting variables.

Logging How-to Topics (SSIS)

Contains procedures for enabling logging for SSIS packages, for selecting log providers, and for choosing the information to log.

Debugging How-to Topics (SSIS)

Contains procedures for setting breakpoints in packages, package executables, and scripts; for configuring error outputs on data flow components; and for using data viewers in a data flow.

Administration How-to Topics (SSIS)

Contains procedures for performing administrative tasks, for managing Integration Services service, and for scheduling packages to run.

Expression How-to Topics (SSIS)

Contains procedures for using expressions in data flow components and in properties.

In addition, the Analysis Services How-to Topics section includes topics that describe procedures for working with data sources and data source views. For more information, see Working with Data Sources How-to Topics (SSAS) and Working with Data Source Views How-to Topics (SSAS).

See Also

Concepts

SQL Server Integration Services

Help and Information

Getting SQL Server 2005 Assistance