SSIS Package Essentials

A package is the object that implements Integration Services functionality to extract, transform, and load data. You create a package by using the SSIS Designer in SQL Server Data Tools. You can also create a package by running the SQL Server Import and Export Wizard or the Integration Services Connections Project Wizard. For more information, see NIB: Designing Packages in Business Intelligence Development Studio and Create Packages.

A basic package includes the following elements:

  • Control flow elements
    These required elements perform various functions, provide structure, and control the order in which elements run. The main control flow elements are tasks, containers, and precedence constraints. There must be at least one control flow element in a package.

    For more information, see Control Flow.

  • Data flow elements
    These optional elements extract data, modify data, and load data into data sources. The main data flow elements are sources, transformations, and destinations. There does not have to be any data flow elements in package.

    For more information, see Data Flow.

For an example of how to create a basic package, see Lesson 1: Creating the Project and Basic Package.

  1. Video, Creating a Basic Package (SQL Server Video), on MSDN.Microsoft.com
Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the rss feeds available on the page.

See Also

Concepts

Integration Services (SSIS) Packages

Precedence Constraints