SSIS

The SSIS service runs SSIS packages in SQL Server Integration services and can be setup to modify writable package-level variables at run time. Statuses of package items and package logs are retrieved as the package executes.

Packages can exist in three locations: as a file in the file system (even on a remote computer), installed in MS SQL, or installed in the SSIS Package Store. If your package is in the SQL Package store, you will need to know the folder in which it is located.

Data can be mapped to any package-level variables.

Packages can be cancelled, but the cancelling mechanism is controlled by SSIS once the task goes active.

The task needs to run on an agent on the same computer as MS SQL Server.
All of the fields described in this page are specific to this service. To get general information for setting up a task, see Tasks.

SSIS Properties

This table describes the SSIS properties:

Field Description
Storage Type

Storage type for the package. These are the available types:

  • File
  • SSIS Package Store
  • SQL Server
  • DB Catalog

The remaining fields change based on the selected Storage type. This table discusses the fields based on the Storage type:
 

Storage

Field

Description

File

Folder

Path or folder where the file is stored.
  Package SSIS Package. Once selected, any package variables for that package will be retrieved.
SSIS Package Store Server SQL Server instance if not using the default SQL Server.
  Folder Path or folder where the file is stored.
  Package SSIS package. Once selected, any package variables for that package will be retrieved.

SQL Server

Login

SQL login that has appropriate permissions.

 

Folder

Path or folder where the file is stored.

 

Package

SSIS package. Once selected, any package variables for that package will be retrieved.
DB Catalog Server

Server hosting the catalog.
  Database Database where the package is stored.
  Project Project where the package is stored.
  Folder

Folder where the package is stored.
  Package

SSIS package. Once selected, any package variables for that package will be retrieved.
Suppress SSIS Logs

SSIS logs will not be stored with the task logs.

Package Variables Section

This section contains a list of variables for the SSIS package. It is automatically populated when the SSIS package is selected. The table contains package variable's properties:

Field Description
Name

Name of the package variable.
Type The external data type of the package variable.
Value Current value defined for the package variable. This value can be modified by specifying the Overwrite option in the detail dialog for the variable.
See Creating a Process to add this task to a process.