SSIS Flat File Destination File Extension Case Issue
Posted on 2011-09-28
I have an SSIS package that formats a flat file for importing into a third party application. The problem I am running into is the file extension of the file destination connection is showing up as upper case and the third party requires lower case. So my SSIS generated file is coming out as "DataFile_CCYYMMDD.POS" and it needs to be "DataFile_CCYYMMDD.pos". All of my variables are showing the file extension as lower case .pos, the file connection manager shows it as lower case, the expression on the connection evaulates to lower case, the script where I concatenate the date into the file name shows lower case extension, but file is written to the hard drive with an upper case extension. I have been unable to find where I can change this. Any help is appreciated.