Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
billsox
Yak Posting Veteran
74 Posts |
 Posted - 2008-06-25 : 09:40:20
|
| Hi -- Just starting to use SSIS and I'm stuck on something. In my situation, we have flat files FTP'd to a "landing" folder, our DTS packages move them to a processing folder, and then the DTS packages move them to an archive folder. I'm trying to create a SSIS package to perform the same actions. Is it better to have one connection for each folder: landing, processing, archive? Or should there just be one flat file connection that gets redirected to the proper location at run time? If it's the latter, what would be the best way to dynamically change the file name? I know that I could use expressions to change the file name but the file name has to change 3 times during one package execution and I don't know what controls when expressions are executed. Any guidance/best practices would sure be helpful. Thanks.Bill |
|
|
billsox
Yak Posting Veteran
74 Posts |
Posted - 2008-06-25 : 10:53:30
|
| Found the answer to my problem at:[url]http://www.sqljunkies.com/WebLog/knight_reign/archive/category/478.aspx[/url] |
 |
|
|
|
|
|
Dynamically changing file names multiple times