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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-07-26 : 07:06:59
|
| Hi,I am using a foreach loop to go through the .txt files inside a folder.Using a variable I can pickup the filenames the loop is going through.At present there is a sql task inside the foreach loop which takes the filename as a parameter and passes this filename to a stored procedure.Now I would like to add one extra step before this sql task. Would like to have a dataflow with flatfile source which connects to oledb destination.The question is:While in the loop, how is it possible to pass the filename to the flatfile source using the FileName variable which I have created?Please note, this is a different question to my other post.Many Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
get filename dynamiccaly