After successfully importing multiple text files using SSIS (MS SQL 2008 R2 ETL Package) into a SQL table, I’d like assistance with the following:
Moving each flat file to an archive folder, maintaining the original file name, file structure and format.
Detailed procedures, code, URL’s, and/or video webinars would be much appreciated. Thanks in advance for the support and guidance.