SQL Server Performance

Move the excel files to archieve folder

Discussion in 'SQL Server 2005 Integration Services' started by sqlserverdeveloper, Apr 15, 2008.

  1. sqlserverdeveloper New Member

    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&timestamp to the filenames, please let me know how I can move those excel files with date&timestamp to the filenames. Any help is greatly appreciated. Thanks!!
  2. jagblue New Member

Share This Page