nishav2 (9/4/2014)
Hi,In C: drive i have many folders .
For example folders named like ABC,ARD,AVB,BGT,BHT etc...And these folders has many subfolders and files in it.
My Task is to search for a string (For example : TASC) in all these folders and sub folders.
I have a for loop container and a script task to do this.But since the data that is found under C: is huge the package runs for more than 1 day.So i thought of splitting this task and do a parallel execution.
I.e.; I can replicate this Forloop container task 23 times(A-Z) and run it parallely.That is one container will look for the main folders(ABC,ARD,AVB) starting with A and another container task will look for
main folders starting with B (BGT,BHT) .similarly i will replicate this container task .All these containers will execute parallely when i run the package.This will take only few hours to complete. i need to achieve this.Can someone help me on this ?
Any help is much appreciated.
Thanks
Nisha V Krishnan
Please start a new thread with your question, instead of hijacking an existing one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP