CODEWITHSUNDEEP
sql-serverssis-2008
James Khan
James Khan

Reputation: 841

Date Format in CSV changed when SSIS package run on Server

Data Flow with 2 tasks, Import Flat File ( Source) and Database(Target). I have a source ( csv Flate file ), data type of [Run Date] is DT_STR in the file format, that goes straight to Database Table where the Column [Run Date] is smalldatetime, sql server 2000.

Now I have a [Run Date] Column in my source file like 05/04/2018.

When I run the SSIS package locally, I get 05/04/2018 in my Import Table in the column [Run DATE]. When I run it on the Server, I get 04/05/2018 as [Run DATE]. This is wrong . How can I ensure SSIS makes the right conversion when it runs the package on the server ? I cannot change the server settings or locale.

Upvotes: 1

Views: 1167

Answers (1)

Ziad Salem
Ziad Salem

Reputation: 525

This issue can be solved by setting the date format of the operating system. On your server go to the control panel and change the date time format to your preference. That should solve the problem.

Upvotes: 1

Related Questions