Flat File connection Manager - File Name, The Folder in File Name changes every time the package is reopoened and needs resetting

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Flat File connection Manager - File Name, The...

13 posts, Page 2 of 2

««1 2

Flat File connection Manager - File Name, The Folder in File Name changes every time the package is reopoened and needs resetting

Rate Topic

Display Mode

Topic Options

Author

Message

Debbie Edwards

Posted Thursday, February 21, 2013 9:11 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 6:33 AM
Points: 415, Visits: 621

kl25 (2/21/2013)

Here's the general approach I use:

1. Set a variable for the path (folder). Learned early on to separate the path because paths that I thought would NEVER change did. Tongue

2. Set a variable for the file name. This is often an expression to allow including the run date or other important but changing aspects of the file name.
3. Set a variable for the full file name. This is always an expression of @Path + @FileName.
4. Set the expression for the connection string to @FileNameFull for the flat file connection manager via the properties window, expressions section.

I think that's what you're doing but I'm not positive.

Ah ha!!!

Ive added the file path in with the file name that is only used to create the CSV files and it seems to have dont the trick. It means that if I change the folder I have to go into the SQL View I have created to alter it but at least it is working.

Yeeeeeeeeey

Thank you, that list was really helpful. Smile