September 18, 2012 at 7:08 pm
Hi Guys,
I'm new to SSIS & I need some assitance around the Flat File Manager concept.
I've designed my whole package and it works successfully; however, I found out when run it as a Job task it fails - I found the issue and it's because in the "Flat File Connection Manager Editor" the filename points to a hardcoded path & file to be inserted into our tables.
e.g. "C:\Datafeeds\df0919.csv
Therefore everyday that filename will change depending on Month & date so tomorrow it will be df.0920.csv .... df0921.csv.... df1212.csv & so on.
Is there any way i can have the filename changed/updated automatically to new filename through a variable or something so it gets picked up.
I've checked online & can't find exactly what I need for my scenario - there are similar ones but when i tried they didnt work.
Thanks
Tava
September 19, 2012 at 7:16 am
Yes, you want to create a variable and the set the flat file connection managers connection string property expression to use the variable that you created for the file name.
Take a look at: http://beyondrelational.com/modules/2/blogs/106/posts/11113/ssis-dynamically-set-flat-file-connection-manager.aspx
HTH,
Rob
September 19, 2012 at 8:06 am
Please don't post your question in multiple forums; it just fragments the responses.
Thanks
September 19, 2012 at 4:36 pm
Thanks for the reply, i did it as a Variable which calls thats expression so worked perfectly.
Sorry i tried to delete it from this thread but didnt know how & forgot to reply as closed.
Thanks again
September 24, 2012 at 12:12 pm
Please check on http://msbi2012.blogspot.in/2012/09/expression.html
September 25, 2012 at 7:43 am
sumit.joshij (9/24/2012)
Or to make it easier for folks :-):
http://msbi2012.blogspot.in/2012/09/expression.html
Rob
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply