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 strange issue is that out of 1000 records that SSIS is importing 200 records have an issue with date where the date data are getting swapped the day became in the place of the year and the year in place of the day.
This is an example of perfect row and problematic row
Perfect row:
2018-12-17 09:05:00.000
Problematic row:
2017-12-18 09:05:00.000
Anyone faced the same issue or knows how to solve please assist.
Thanks
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…