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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Multi File Import

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

Posted - 2010-03-02 : 12:34:25
see

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -