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
 General SQL Server Forums
 New to SQL Server Programming
 SSIS Looping

Author  Topic 

pravin14u
Posting Yak Master

246 Posts

Posted - 2007-03-19 : 01:40:20
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:45
Another dupe http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80781


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

pravin14u
Posting Yak Master

246 Posts

Posted - 2007-03-19 : 01:44: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

pravin14u
Posting Yak Master

246 Posts

Posted - 2007-03-19 : 01:47:36
Apologies for the dupe entry
Go to Top of Page
   

- Advertisement -