SSIS - Package



A package defines a workflow of tasks to be executed

  • An unit of task flow execution
  • An unit of deployment (package deployment model)

You can execute each package independently, and you can also use the Execute Package task to run one package from another.

File Extension: dtsx


You can also create a package template.

  1. Create a package that includes the elements you want to reuse.
  2. Save the package to the DataTransformationItems folder (By default, C:\Program Files (x86)\Microsoft Visual Studio 10.0 \Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject)
  3. Reuse the package by adding a new item to the project and select the package in the Add New Item dialog box.
  4. Change the Name and ID properties of the new package to avoid naming conflicts.


A dynamic package is a just a normal package where:

because their values can be set dynamically at run time.

Discover More
SQL Server - Integration Services (SSIS)

It is a platform for ETL operation (Developed by MicroSoft). SSIS is (a feature of|included with) SQL Server (introduced in 2005 is the new DTS (Data Transaction Services) platform). SSIS consists...
Ssis Connection Properties Editor
SSIS - Connection

You can create connection managers at the project level or the package level. Project-level connection managers are listed in Solution Explorer and can be shared across multiple packages in the same...

Share this page:
Follow us:
Task Runner