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