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.
July 20, 2020 at 7:40 am
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
Hi, Thank you Anand929.
can you send me any tutorials for understanding SSIS. black friday vpn deals
I am a designer.
July 20, 2020 at 12:35 pm
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 20, 2020 at 8:54 pm
Perfect thanks anthony.green and anand929
July 22, 2020 at 3:54 pm
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
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