kris norman
asked on
ssis XML source converting UTC to local time
I have a SSIS package with
XMLSource as source and the output is writing it to the table.
XMLSource ->Table (with DateTime coloumn)
The problem is the XML file has datetime values in UTC like
2013-02-12T04:00:00Z
when the SSIS parse it, it is changing it to local time. But i dont want this to happen. i.e. SSIS should not convert the datetime in the XML to local time. how to stop this conversion. Any one having similar experience. please help.
The DataType that I'm using is "database date [DT_DBDATE] " on the Derived Column Transformer.
As always, Thanks for your help!
XMLSource as source and the output is writing it to the table.
XMLSource ->Table (with DateTime coloumn)
The problem is the XML file has datetime values in UTC like
2013-02-12T04:00:00Z
when the SSIS parse it, it is changing it to local time. But i dont want this to happen. i.e. SSIS should not convert the datetime in the XML to local time. how to stop this conversion. Any one having similar experience. please help.
The DataType that I'm using is "database date [DT_DBDATE] " on the Derived Column Transformer.
As always, Thanks for your help!
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER