Use a variable for a file connection manager

Question

Use a variable for a file connection manager

Jay@Work

SSCrazy

Points: 2633
More actions
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
Ant-Green

SSC Guru

Points: 113507
More actions
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.

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

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

Anand929 Grasshopper Points: 22 More actions · Answer 1

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

adamedge Grasshopper Points: 16 More actions · Answer 2

Hi, Thank you Anand929.

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

This reply was modified 4 years, 5 months ago by adamedge.

I am a designer.

Phil Parkin SSC Guru Points: 246987 More actions · Answer 3

adamedge wrote:

Hi, Thank you Anand929.
can you send me any tutorials for understanding SSIS.

You could try this.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Jay@Work SSCrazy Points: 2633 More actions · Answer 4

Jay@Work

SSCrazy

Points: 2633

July 20, 2020 at 8:54 pm

#3771538

Perfect thanks anthony.green and anand929

Anand929 Grasshopper Points: 22 More actions · Answer 5

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

thomaskin Newbie Points: 1 More actions · Answer 6

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.