Average: 2.8 (6 votes)


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.

Requirements

Depends on COZYROC Script Task Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain