Column Names cAsE SeNSitive? - DFT

Does the column names are case sensitive for the DFT? Recently in one of table, the column names were changed to Upper Case from Lower case and the package started failing in validation. Is there any solution / work around for this?

Thanks

Is the database itself case-sensitive?|||

No the database is not case sensitive. I can use mixed cases for column names in Management Studio/Query Analyzer, I still get results. Only in SSIS it fails, especially when you modify the column case after the package is created.

This is what I have:-
A simple DFT task.
OLE DB Source is Sybase, OLE DB Destination is SQL SERVER 2005. No other transformations in between.
Sql Server has columns in lowercase when the package was developed, but later somebody recreated table with columns in upper case and package started to fail in validation.

Thanks

|||

Can any one tell me if this is the behaviour?

Thanks

|||

Karunakaran wrote:

Can any one tell me if this is the behaviour?

Thanks

Yes, this is confirmed in SP2. I agree, this probably should not be designed to be case sensitive. Can you post a bug at http://connect.microsoft.com/sqlserver/feedback? Then post back here with a link to the submission?

Thanks,
Phil|||

I have submitted the bug, below is the link.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=296668

Thanks