How to give versioning to my folder in SSIS using FST
Hi, Every time i run my package , i create dome folders dynamically using FST . But i want to maintain a version for it . How can i create folder with versions ?? I used timestamp but , what happenes is after the folder is created and till the time the package comes to moving files to that folder the time stamp changes. Let me know how can i give a version say : BATCH1_V1 OR nething like that . I have different packages that has different functions so i cannot use the variables also. Thanks & Regards, Bhavika
April 20th, 2011 10:35am

If this is a question then a wrong post type was used. I suspect you still should use a package variable but you may want to populate it off a database table in which you would maintain the versioning the way you want. Would this proposition make sense?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 20th, 2011 10:37am

thanks for pointing it out, by mistake i selected it as Discussion .. anyways i will delete this Discussion.Thanks & Regards, Bhavika
April 20th, 2011 10:44am

I suspect you still should use a package variable but you may want to populate it off a database table in which you would maintain the versioning the way you want.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 20th, 2011 10:46am

Need to understand the term "Versions" here. Is it like the source safe versioning or maintaine different names to each folder. If it is different names to different folders , File system task can create the directories with different names dynamically with "Create directory operation" . Is this what you are looking for ? Or when ever the files are written into the folder , for each write you want the version maintained somewhere? "I have different packages that has different functions so i cannot use the variables also. " Why cant varaibles be induced eventhough there are existing funcitonalities? It can be done.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
April 20th, 2011 12:16pm

I want to give different names to my folders ??Thanks & Regards, Bhavika
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 2:02am

check SCRIPTS step 2 ans 13 in http://plexussql.blogspot.com/2010/04/looping-through-excel-files-and-sheets.html this will give you an idea what to do in the blog it is basically using DATE as the BACKUP FOLDER name and in step 13 as rebanimn the file with its original name and date stamed WHAT you need it use a variable to set YOUR VERSION (NOT THE PACKAGE VERSION) and each time you have to change it just change the variable in a SSIS CONFIG File or table good luck Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).
April 21st, 2011 9:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics