For Each Loop container - SQL Server Forums

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 2005 Forums

SSIS and Import/Export (2005)

For Each Loop container

Author

Topic

kkiranvr
Yak Posting Veteran

54 Posts

Posted - 2008-07-22 : 22:11:01

my scenario is, i have 4 fies
FileAccount_full.csv
FileSub_full.csv
FileAccount_delta.csv
FileSub_delta.csv

Now i need to insert data from these files to SQL table, for this i have used 2 foreachloop container in that i am searching for *full*.csv file and if it fails it should search for *Delta*.csv files.

now each "full" and "Delta" files having both account and sub, so how can i look now for Account or Sub using foreach loop container?

Totally i need to use 3 dataflow tasks.

-Thanks N Regards,
Chinna.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-23 : 05:10:02

You need only a single foreachloop container . just use a conditional task to look for presence of delta or full and accordingly add tasks to two outputs
are account & sub fields within files?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources