August 19, 2015 at 6:52 pm
Hello, I'm having a hard time trying to transform a date that comes in for import in this format: 2015-04-08T18:00:48.000Z to DT_DBTIMESTAMP, I get potential loss of data error. (I've tried other SSIS data types.)
I had never seen this type of date before so I'm at a loss.
Any help will be appreciated.
TIA
August 19, 2015 at 9:03 pm
monicaroman (8/19/2015)
Hello, I'm having a hard time trying to transform a date that comes in for import in this format: 2015-04-08T18:00:48.000Z to DT_DBTIMESTAMP, I get potential loss of data error. (I've tried other SSIS data types.)I had never seen this type of date before so I'm at a loss.
Any help will be appreciated.
TIA
That looks to be datetimeoffset (SQL type). I believe the name of the SSIS most appropriate for that is DT_DBTimestampOffset
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
August 20, 2015 at 12:55 pm
Thank you Matt, that worked. I set the type to DB_TIMESTAMPOFFSET(databae timestamp with timezone) and I get a date. I don't get the hh:mm:ss but that is fine for now. 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply