SSIS: download and process ftp files
Posted on 2011-03-04
I'm trying to build a package that will download any files from an ftp site. The process consists of getting the file list in the ftp directory, looping through each one filename in the recordset and processing each file individually.
I've got it to a point where I get the file list, if the file count > 0 then perform a ForEach loop which does a ForEach Variable Enumerator based on a recordset containing the names in the remote directory and maps a object variable that stores the remote file name to be processed in the script. This is where I'm stuck. In the script I can't seem to access the value of the remote filename.
Does anyone done a similar routine and can provide info or links to reference material on how to accomplish this, or how can I extract the remote filename data I need?