Using the script task I am checking for the excel file existence and upon file existence, then using the data flow task loaded the excel data into sql table. After the data is loaded from one file or however number of excel files present, I want to move those excel files into a archieve folder with date×tamp to the filenames, please let me know how I can move those excel files with date×tamp to the filenames. Any help is greatly appreciated. Thanks!!
Hi, Look at this link for the answer http://dichotic.wordpress.com/2006/11/14/source-file-archiving-ssis-versus-datastage/ Hope this will help you Thanks