June 24, 2010 at 5:21 am
Hi,
every day i have to import a file which has the name FileName0000x.(first file will be FileName00001, second FileName00002... )
so i couldn't find a solution to create a dynamic name in the properties of file connection(i tried to add an expression).
do you have any ideas to find the daily file ?
Thanks in advance .
nailosuper.
June 24, 2010 at 6:01 am
I would store the filename in a configuration table. At the beginning of the package, read the filename and set the connection string with an expression. At the end of the package, update the configuration table with the next filename.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2010 at 7:45 am
I usually use the foreach loop and just specify a pattern (i.e. filename*.txt) and dynamically build the connection. Depending on the project I'll also store the filename in a table and compare it to what I'm about to load. If it's not in the table, load it.
June 25, 2010 at 9:10 am
[font="Comic Sans MS"]
I do it exactly as da-zero mentioned.
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply