How to look for folder starting with some alphabet alone

• nishav2

  SSCrazy

  Points: 2224

  More actions

  September 4, 2014 at 10:41 am

  #311351

  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

• rxm119528

  SSCrazy

  Points: 2960

  More actions

  September 4, 2014 at 2:36 pm

  #1743349

  As suggested in the post http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html

  you can use the script task.

  A few tweaks like adding a for loop container with in a for loop container should be done to meet your requirment.