Post reply

Use a variable for a file connection manager

  • July 20, 2020 at 3:09 am

    Go to Answer

    #3771207

    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

     

  • July 20, 2020 at 6:54 am

    Answer

    #3771230

    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.

  • July 20, 2020 at 7:40 am

    #3771240

    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

  • July 20, 2020 at 11:35 am

    #3771279

    Hi, Thank you Anand929.

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

    • This reply was modified 3 years, 11 months ago by  adamedge.

    I am a designer.

  • July 20, 2020 at 12:35 pm

    #3771292

    adamedge wrote:

    Hi, Thank you Anand929.

    can you send me any tutorials for understanding  SSIS.

    You could try this.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • July 20, 2020 at 8:54 pm

    #3771538

    Perfect thanks anthony.green and anand929

  • July 22, 2020 at 3:54 pm

    #3773858

    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

  • May 5, 2021 at 3:23 pm

    #3879650

    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 7 (of 7 total)

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