Working with single Files: The FTP Task (Part 1)
demonstrates using FTP to download 1 specific fileWorking 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
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