Need regex with ssis foreach Loop

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  February 15, 2016 at 1:49 pm

  #308050

  Hey guys, working on copying all files that have a name that has nine numbers in the name and has a pdf extension into another folder using a forEach Loop. I'm using the following regular expression in the files folder for the foreach loop "[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9].PDF". Problem is that the forEach loop never finds any files. Should I be using #########.PDF? I need to include the number of digits because the person requesting this doesn't want any files with 10 digits and the do wxist in the folder with 10 digits