October 2, 2018 at 8:20 am
Hi Experts,
I have a csv file with a date column with 2018-09-20 10:26:00 AM.
Inside the SSIS package preview it shows as 20 Sep 18 10:26
and when i load to a table column with date as data type it shows 2020-09-18.Please help i want the result to be '2018-09-20''
Thank you so much
T
October 2, 2018 at 8:44 am
tmmutsetse - Tuesday, October 2, 2018 8:20 AMHi Experts,
I have a csv file with a date column with 2018-09-20 10:26:00 AM.
Inside the SSIS package preview it shows as 20 Sep 18 10:26
and when i load to a table column with date as data type it shows 2020-09-18.Please help i want the result to be '2018-09-20''Thank you so much
T
Not sure what sort of help you expect. We can't see your code. I'd suspect a dodgy expression somewhere, but that's just a guess.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply