May 4, 2010 at 12:25 pm
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.
May 4, 2010 at 12:46 pm
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.
May 4, 2010 at 1:41 pm
Thanks for your reply. Yes, SQL 2000.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply