Day And Year Got Swapped Ssis And Sql Server

I got strange issue between SSIS and SQL Server. I've developed SSIS to read CSV flat files and upload the files to SQL Server. Everything is working great and perfectly. The stra

Solution 1:

Just try to convert the date format while loading into tables in ssis/after loading into table just update the records into a proper datetime format using convert function in backend.

In Csv itself getting mixed format in the sense just push it into staging table and split up the problematic records and correct the source data.

Solution 2:

The following steps supported me to sort out the issue:

1. Set the PC format to be dd-mm-yyyy hh:mm:ss
2. Open the CSV file and try to expand the columns which is having the issue.
3. Close the CSV file and save the changes.

and run the SSIS.

Hope that will help you too