Post reply

How to give versioning to my folder in SSIS using FST

  • April 20, 2011 at 8:31 am

    #389330

    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.

  • April 20, 2011 at 8:40 am

    #1313991

    bhavika.chauhan (4/20/2011)

    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.

    First, come up with a consistent version-numbering scheme - Folder_v01, Folder_V02 or whatever.

    Second, do your folder creation using a Script Task. Within the Script Task, you could also assign the new folder name to a variable, to be used elsewhere in the package.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 20, 2011 at 8:46 am

    #1313995

    Hi Phil,

    I do not have to use any scripts. no coding stuff. So I think i need to create some expression like that that will generate Folder_v1 etc. Can you guide me with the expression for this ??

  • April 20, 2011 at 11:46 am

    #1314137

    Bhavika, What is this FST by the way

    __________________________________________
    ---------------------------------------------------
    Save our mother Earth. Go Green !!!

  • April 20, 2011 at 11:30 pm

    #1314305

    Its File System Task

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply