SSIS - Connection manager Variable file name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » SSIS - Connection manager Variable file name

SSIS - Connection manager Variable file name

Rate Topic

Display Mode

Topic Options

Author

Message

Tava

Posted Tuesday, September 18, 2012 7:08 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:58 PM
Points: 76, Visits: 297

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

Post #1361076

robert.gerald.taylor

Posted Wednesday, September 19, 2012 7:16 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 1:48 PM
Points: 740, Visits: 787

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

Post #1361314

robert.gerald.taylor

Posted Wednesday, September 19, 2012 8:06 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 1:48 PM
Points: 740, Visits: 787

Please don't post your question in multiple forums; it just fragments the responses.

Thanks

Post #1361376

Tava

Posted Wednesday, September 19, 2012 4:36 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:58 PM
Points: 76, Visits: 297

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

Post #1361689