SSIS Flat File Destination File Extension Case Issue

Hello all,

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.
LVL 1
HooznextAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MrNeticCommented:
Hi,
If you are running this as a job, you should check if someone else has changed the ssis job step, incluing package configurations and datasources.
0
Alpesh PatelAssistant ConsultantCommented:
At end of the Package use File system task and rename the file.
0
HooznextAuthor Commented:
MrNetic, it is not in production yet, I am running this through Visual Studio. It is ready for final testing as soon as I figure out why all the extension are capital letters.

Patel, I could do this, depending on the day there can be thousands of files created by this job, to have to loop over them and rename them would introduce more overhead, I'd rather have the files named appropriately when they are created. This idea is a last resort for me.
0
HooznextAuthor Commented:
I forgot this was still open, I found a query that was setting the extension to upper case after the fact. It was not an SSIS issue, but a database admin issue, sorry.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HooznextAuthor Commented:
Was an issue created by an admin in our database, nothing to do with SSIS.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.