I use SSIS 2005 to read data from a CSV file into a SQL Server 2005 database. I use a flat file connection manager for CSV and OLEDB Connection Manager for the resulting rows.
The .csv file contains a field that is a date in the UK format (dd / mm / yyyy), which can be written on, say, 7/3/2011 for March 7, 2011. This column is then mapped to the datetime equivalent in the SQL Server database.
The problem I am facing is that although everything works well on the development machine when used in a production environment, the dates change in the US format (mm / dd / yyyy) (if they are valid) when they are inserted into SQL Server Is there some place where the desired region / format (in this case, Great Britain) for the datetime destination field can be specified, perhaps somewhere in the package or some kind of setting on the production server itself?
Thanks in advance Tim
source
share