November 2, 2014 at 9:28 pm
We have a 2008 DTSX that takes a client XLS file and loads it. The file and our environments use non-US day-month format, ie: DD-MM-YYYY.
Our Dev/Test environments are physical servers in our computer room running SQL2008, and we are in the process of moving to AWS RDS SQL2012 servers for Stage/Prod.
We experienced an issue on Prod whereby dates that could be interpreted in US-style MM-DD-YYYY were done so, but other dates were kept in non-US-Style; that the DTSX loaded dates in both US and non-US styles. ie: 5-Aug-2014 would be loaded as 8-5-2014, but 13-Aug-2014 would be loaded as 13-8-2014. No "invalid date" errors were raised.
Analysis showed that only the Prod copy of the DTSX had this behviour and refreshing the DTSX fixed this issue.
My question: has anyone seen this behavior previously?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply