September 21, 2010 at 2:37 pm
I am working on my very first SSIS package and it is a simple one 🙂
All i am doing is grabbing data out of a text file "mail_test.txt" and inserting into a table. When I am done with that i want to change the file name to "mail_test.old".
I am using the multi file data connection so there will be many .txt files that I want to rename immediately after they are processed so they will be ignored the next time around.
I have seen a lot of posts about setting variables and the like but I have no idea how to do that in SSIS, is there a tutorial that I can view somewhere or is it easily explanable within the forum?
TIA, Jordan
September 21, 2010 at 7:44 pm
Hi Jordan
I had to do this using a loop before - i.e. copy a file between a current folder to an archive folder and rename the file... I have documented the process for future - not sure if this could possibly help u.
let me know if you would like to and i can send it to you
Cheers
Vani
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply