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 |
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-02 : 11:55:34
|
If you have a SSIS job with a ForEach loop container, fetching csv files from a directory, how do you pass this to the next box. It's on Control Flow. The underlying Data Flow Flat File Task pulls a single file to a SQL table destination successfully. Now getting the multi files, how do you connect these together?What's happening now: the import happens for that number of files in the directory, but is actually importing the same file defined in Data Flow.I don't quite understand the green line connection, because Control and Data Flows don't exist on the same screen... |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|