Post reply

File System Task - Rename using connection manager

  • January 2, 2009 at 9:13 am

    #155077

    I hope I am not being thick, but I am trying to move a file from one folder to another and rename the file with some variable information. I can do this with using a variable that has a hard-coded folder and concatenates some other variables to embed a date and frequency into the name of the file. What I want to do though is to use a connection manager and a file name that is concatenated variables and whatever. I want to do this so when testing I can just point the connection manager to a test folder and when testing is done I can just repoint it to production. I don't want to have to change coding in the variables if possible. An example is:

    move C:\inputfldr\INPTFILE.TXT to C:\archive\INPT1221W.TXT

    The INPT1221W.TXT name can be handled with something like: "INPT" + @[User::strMMDD] + [User::strFREQ] + ".TXT", but I want the folders to be connection managers. Does anyone know if this is possible?

  • January 2, 2009 at 12:42 pm

    #920490

    GoofyKC (1/2/2009)

    I hope I am not being thick, but I am trying to move a file from one folder to another and rename the file with some variable information. I can do this with using a variable that has a hard-coded folder and concatenates some other variables to embed a date and frequency into the name of the file. What I want to do though is to use a connection manager and a file name that is concatenated variables and whatever. I want to do this so when testing I can just point the connection manager to a test folder and when testing is done I can just repoint it to production. I don't want to have to change coding in the variables if possible. An example is:

    move C:\inputfldr\INPTFILE.TXT to C:\archive\INPT1221W.TXT

    The INPT1221W.TXT name can be handled with something like: "INPT" + @[User::strMMDD] + [User::strFREQ] + ".TXT", but I want the folders to be connection managers. Does anyone know if this is possible?

    Yes, you can do it. Right-click on your file connection manager and select Properties. Then scroll-down and select Expressions property. Specify the property you want to modify and define expression for it.

    You can use different package configurations for your test and production scenarios.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 2, 2009 at 1:20 pm

    #920517

    CozyRoc, Thanks for the info.

Viewing 3 posts - 1 through 2 (of 2 total)

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