I am building a SSIS which will look for 2 files which will have <filename>Month year.xls.
I want to build the SSIS so it is fully automated I have everything working except I can't figure out how to either just look at the first 10 letters of the file name or ?? maybe there's a better way
Any help is much appreciated.
I am trying to do this with a Data Flow Task in case there is another way