SSIS Package task

The SSIS task would be used for the following scenarios:

  • Reuse existing SSIS packages
  • Where complex extraction and transformation is required that is not covered in Loome Integrate

From the task type screen, select SSIS Package.

Adding a SSIS Package task

Task Name

Enter a unique task name here. Task names must be unique to a project.

Package Name

Specify the SSIS package you want to add to the task by either entering the package name into the text field or select it by clicking on SSIS Pack Browser. Loome Integrate can only execute packages on the database server’s SSIS package store. It can not execute an SSIS package that is located on a remote server.

Once you have selected the package from the drop down, click Add Selected.

Tip: The package name must be in the format of /. The list of packages in the SSIS package browser are derived from the package location in the System Settings.

Last End Point

Primarily used to display Data Currency and to support incremental processing. This is a read only field. The last end point indicates where the cut off point is for the data source that the SSIS package is referring to. This could be a time stamp, transaction ID, row number etc.

Connection for Incremental

Select a Connection for Incremental. All predefined connections will be listed in the drop down list.

Refer to Table Names, Incremental Data and Index Migration for more information on incremental configuration.

Advanced Settings

Toggle to show or hide the advance settings. Advanced settings are different for each task type.

Subject Areas:

Select Subject Area for the task if applicable. Refer to Using a Subject Area for more information.

Parameters:

Adding a parameter in Loome Integrate is a 2 step process. The parameter names are created in the task details screen and subsequently the parameter values are assigned in the Parameters And Dependency screen. Here we are just adding the name of the parameter. No value has been assigned to this parameter.

For a SSIS Package task you have the option to add a parameter. This section allows variables to be set during execution of the SSIS Package.

Enter the Parameter Name and click Add Parameter. This will create a list below the field. You can continue adding more parameter names if required. When you have added a parameter name, it will appear in the parameters list.

Parameters

Once you have created the task, follow the instructions for Configuring Parameters and Dependency to assign a parameter value to the task.

Tip: The parameter values are set in a different place to where it is created. This is to allow for the same task to be added to a Job (or multiple Jobs) with different parameter values passed each time it is run.

Logging:

Logging

You can choose to select task logging.

Select a logging level. Logging options vary depending on the task type selected.

The available logging options for a SSIS Package task type are:

  • Standard - the default logging level as provided by Loome Integrate
  • Debug - the standard logging level with additional logging to assist with investigation of issues
  • Save Packages - the standard logging level with actual SSIS package to nominated disk location (primarily used for issue resolution)
  • Save Packages & Debug Logging - all of the above

Tip: If you have both job logging and task logging on- when job logging is set to Standard then the task logging option will override this. Otherwise job logging will always take precedence.

Action Buttons

When you have entered all the necessary task details, click Save.

Information: Task saved!

An information box will appear to confirm that the task has been successfully saved. Click Close.

Tip: New tasks are added to the bottom of the list as Enabled.