Use a variable for a file connection manager

  • How do I tell a file connection manager that the file in question is not a static name and will change daily?

    I have a string variable that builds the daily expected filename but can't see how to use this.

    SSDT wants me to enter the name of an existing file... which I can do as a placeholder but will need to overwrite at run time

     

  • You would set the expression of the FileName property or the ConnectionString property which ever you are building to be that of the parameter either at package or project level depending where the parameter is defined.

    As you say it will need to be a static file initially to build the validation and workflow correctly, but at runtime it will execute dynamically and build and swap in the required value.

  • Assuming, this question is regarding SSIS, you can follow below steps -

    1.      Right click file connection Manager and select Properties. Alternatively, you can select file connection manager and press F4.

    2.      Select browse button (three dots) against “Expressions” property.

    3.      Select “ConnectionString” under Property and click on browse button, it will open expression builder.

    4.      In the Expression box, drag the variable which contains complete file path.

    Anand

  • Hi, Thank you Anand929.

    can you send me any tutorials for understanding  SSIS. black friday vpn deals

    • This reply was modified 1 year, 4 months ago by  adamedge.

    I am a designer.

  • adamedge wrote:

    Hi, Thank you Anand929.

    can you send me any tutorials for understanding  SSIS.

    You could try this.

    If you aren't happy single, you won't be happy in a relationship.

    Remember, happiness comes from guitars, not relationships.

  • Perfect thanks anthony.green and anand929

  • adamedge wrote:

    Hi, Thank you Anand929.

    can you send me any tutorials for understanding  SSIS.

    Hi Adamedge, Thanks for asking. There are many good tutorials available for SSIS. One of them shared by Phil Parklin. I also like and many times refer - https://www.tutorialgateway.org. Hope that helps.

    Anand

  • As you say it should be a static record at first to fabricate the approval and work process accurately, however at runtime it will execute powerfully and assemble and trade in the necessary worth.

Viewing 8 posts - 1 through 8 (of 8 total)

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