Solved

SSIS Flat File Destination File Extension Case Issue

Posted on 2011-09-28
5
648 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Hooznext
  • 3
5 Comments
 
LVL 5

Expert Comment

by:MrNetic
ID: 36716514
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
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36716781
At end of the Package use File system task and rename the file.
0
 
LVL 1

Author Comment

by:Hooznext
ID: 36716930
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
 
LVL 1

Accepted Solution

by:
Hooznext earned 0 total points
ID: 37430195
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
 
LVL 1

Author Closing Comment

by:Hooznext
ID: 37453037
Was an issue created by an admin in our database, nothing to do with SSIS.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now