Script Package Configuration Task

Overview

Script task for alternative SSIS package configuration setup.


Setup

The script has the following parameters:

  • PackageConnection - the connection manager providing the package.
  • ConfigurationEnvironment - system environment variable containing the path to the Excel configuration file.
  • ConfigurationWorksheet - Excel worksheet containing the configuration.

The configuration is contained in Excel worksheet with two columns:

Script Mail Task

Overview

Script task providing management functions for email server.


Setup

The script has the following parameters:

Script HTTP Upload Download Task

Overview

Script task to upload or download file using HTTP protocol.


Setup

The script has the following parameters:

Script Get FTP File List Task

Overview

Script task to get remote FTP files list.


Setup

The script has the following parameters:

  • FtpConnection - FTP connection manager selection.
  • RemotePath - path of remote files list to get.
  • ResultVariable - package variable where result files list is stored. The type of variable should be Object.

Script FTP File Exists Task

Overview

Script task to verify for existence of remote FTP file.


Setup

The script has the following parameters:

Script Find And Replace Task

Overview

Script task to perform find and replace.


Setup

Script to:

Script File Checksum Task

Overview

Script task to calculate a checksum for a file. The result is stored in package variable.


Setup

The script has the following parameters:

Script File Info List Task

Overview

Script task to manage IFileInfo list.


Setup

The script has the following parameters:

Script AS2 Send Task

Overview

Script task to send electronic documents (EDI, XML) using Applicability Statement 2 (AS2) specification.


Setup

The task has the following parameters:

Script File Exists Task

Overview

Script task to check for TargetFile file existence. The result is stored in Result variable.


Setup

The task has the following parameters:

  • TargetFile - selects FILE Connection.
  • Result - selects variable where the result is stored.

Pages