SSIS Package Essentials

SSIS Package Essentials

 

Applies To: SQL Server 2016 Preview

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 Create Packages in SQL Server Data Tools and Run the SQL Server Import and Export Wizard.

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.

Community Additions

ADD
Show:
© 2016 Microsoft