September 18, 2013 at 2:14 pm
How to specify for dynamic filename in SSIS flat file source
for file 20110818_abc_def.csv
as the name abc_def does not changes only the date part changes. so how to make it dynamicaly and also the file source location does not change.
Any clue on it.
Shaun.
September 18, 2013 at 2:21 pm
Try this and let us know if you run into any issues.
September 19, 2013 at 9:28 am
can i send an e-mail with the issue. I do have a packaage alaready existed but it has to be done for 2 more files but name changes.. so i'm getting lost in it.. As the files will be generated to the same location but those 2 files addition to it..
September 19, 2013 at 9:52 am
The for-each look is your friend, along with some variable manipulation.
September 19, 2013 at 9:52 am
i am geting lost no idea how to do it.. im new in it..
September 19, 2013 at 3:17 pm
Shaun2012 (9/19/2013)
i am geting lost no idea how to do it.. im new in it..
The article suggested by Chrissy321 should walk you through how to do a dynamic expression for a flat file connection. It's got the steps to set one up pretty clearly described. Your package will end up with a connection set up in much the same way. If you have multiple files, set up the connection first (see the article) and then you can move on to the for/each loop suggested by Manic Star.
So start with the suggestions you've already gotten, particularly the article. If you have specific issues as you try to do that, let us know what you've tried and what you're having difficulty with.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply