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)
 SSIS Looping

Author  Topic 

pravin14u
Posting Yak Master

246 Posts

Posted - 2007-03-19 : 01:39:37
Hi All,

I have 12 files pertaining to 12 months in a folder(ex: Jan.txt,Feb.txt... Dec.txt).

I want to loop through these file in order (Jan,Feb...dec).

How can implement this in SSIS?

Thanks,

Prakash.P

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-19 : 01:41:22
You can use FOR EACH container.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

pravin14u
Posting Yak Master

246 Posts

Posted - 2007-03-19 : 01:46:32
Hi,

I tried using it. But the issue is that I need to loop through the files in a specific order(Jan... Dec). I dont find an option to specify the order in FOREACH container.

Can you please advice me on this?

Thanks,

Prakash.P
Go to Top of Page
   

- Advertisement -