Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Flat File connection Manager - File Name, The Folder in File Name changes every time the package is reopoened and needs resetting Expand / Collapse
Author
Message
Posted Thursday, February 21, 2013 9:11 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:58 AM
Points: 423, Visits: 635
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.
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.
Post #1422661
Posted Thursday, February 21, 2013 9:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 461, Visits: 1,686
You're welcome. Glad you got the issue worked out.
Post #1422666
Posted Thursday, February 21, 2013 9:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:58 AM
Points: 423, Visits: 635
kl25 (2/21/2013)
You're welcome. Glad you got the issue worked out.


Your Full File Name made me realise where I was going wrong. Thank you again. What a day
Post #1422669
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse