Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS 2008 - Question Marks in Filemask don't seem to work in ForEach Expand / Collapse
Author
Message
Posted Thursday, May 8, 2014 11:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 20, 2014 12:45 PM
Points: 7, Visits: 181
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.
Post #1569047
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse