SSIS 2008 - Question Marks in Filemask don't seem to work in ForEach

• Jon Brune

  Old Hand

  Points: 373

  More actions

  May 8, 2014 at 11:38 am

  #293090

  I have a folder with 2 types of files:

  1) ABC_yyyymmddhhmmss.csv

  2) ABC_Daily_Report_yyyymmdd.csv

  So, I set my FileSpec in my ForEach loop to ABC_??????????????.csv. The problem is my ForEach is finding BOTH file types. It seems to me there is no way it should be catching file (2). Anyone see anything I'm missing?

  I'm using SSIS 2008R2.