Friday 20 March 2015

SSIS FTP task downloading files


Working with  single Files: The FTP Task (Part 1)

demonstrates using FTP to download 1 specific file

Working with single Files: The FTP Task (Part 2)

demonstrates a data flow task for loading the downloaded flat file into the DB


How to Download Multiple Files with the FTP Task (Part 1) 

demonstrates using wildcards for filenames to download 4 specific files
How to Download Multiple Files with the FTP Task (Part 2) 

demonstrates loading the 4 downloaded files using a foreach loop container and a filename user variable




SSIS control flow: 

I have added an additional step to move the files from the import directory to an archive directory


No comments:

Post a Comment