• 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