Rename file, Run DTS, Move file

• SQLNewbie-1002660

  SSC Enthusiast

  Points: 162

  More actions

  May 4, 2010 at 12:25 pm

  #222100

  Hi Experts,

  Really appreciate your time and thank you in advance for your inputs. I am looking to create a job with the foll 3 steps in this order and was wondering if you would be kind enough to share your expert suggestions:

  I did some reading and research and I believe this is what I am looking for -

  1. Rename a .csv file that gets dropped off in a folder location (say, 'data_folder')

  2. Run a DTS on the newly renamed file (I figured the DTS part and got it to work - renaming in 1 because DTS can pickup only a pre-defined filename)

  3. Rename the file to mmddyyyy.csv

  4. Move the file to an archive folder (say, 'older_versions')

  - All files, folders and DTS are on the server.

  I would highly appreciate if anyone can share an existing code or instructions to make this possible.

  Warm regards and thank you so much.

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  May 4, 2010 at 12:46 pm

  #1162039

  Since you state DTS I assume you are doing this on SQL 2000?

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

• SQLNewbie-1002660

  SSC Enthusiast

  Points: 162

  More actions

  May 4, 2010 at 1:41 pm

  #1162068

  Thanks for your reply. Yes, SQL 2000.