Iterate through folders in SSIS
Hi all, I have at one main folder which contains 10 folders each which have a text file in each. I would like to iterate through all 10 folders for the main folder and load the text files ...I cant seem to know how to do this (ino how to iterate through files but how to iterate through main folder then folders within it then files within each folder) please help
February 16th, 2011 6:19am

Go through this link http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/0e97ce79-3266-4070-8c1f-cbe11b437195/
Free Windows Admin Tool Kit Click here and download it now
February 16th, 2011 6:21am

Use Foreach loop Container and check the option Traverse Subfolder to traverse subfolder See the post for similar problem http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b7b637f0-05a7-4f0d-84f5-d68515b01fde/ Cheers, Shailesh
February 16th, 2011 6:22am

Hi all, I have at one main folder which contains 10 folders each which have a text file in each. I would like to iterate through all 10 folders for the main folder and load the text files ...I cant seem to know how to do this (ino how to iterate through files but how to iterate through main folder then folders within it then files within each folder) please help I've outlined a few options here: Processing data from multiple files all at oncehttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
Free Windows Admin Tool Kit Click here and download it now
February 16th, 2011 6:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics