locked
Datetime conversion in SSIS RRS feed

  • Question

  • Hi All,

    I have a query regarding datetime conversion in SSIS.

    I have a XML feed which is being generated from another system. It has a XML element with value in the format " 2012-11-29T19:22:00-05:00 "

    When this XML feed is imported into the MS-SQL  using SSIS XML Source task, the value gets converted and is stored as " 30-11-2012 05:52:00 " . Not sure how the conversion happens.

    Same for other values too.

    " 2013-02-11T11:13:32-05:00 " gets converted to " 11-02-2013 21:43:32 "

    Monday, May 27, 2013 6:35 AM

Answers

  • Hi Surendra,

    Thanks for the reply. I figured this out.

    This was working when tested in the QA enviornment.

    I was running the process from my local machine which had a different time zone compared with the one on QA m/c, that's why the issue.

    Yes, -05.00 in the data that tells about the time zone which is (GMT - 05.00)




    • Marked as answer by S Prashant Monday, May 27, 2013 9:30 AM
    • Edited by S Prashant Monday, May 27, 2013 9:34 AM
    Monday, May 27, 2013 9:30 AM

All replies

  • Hi Prashant

    If you insert 2012-11-29T19:22:00 in Datetime column it will work .  what is that -05:00 ?


    Surendra Thota

    Monday, May 27, 2013 8:47 AM
  • Hi Surendra,

    Thanks for the reply. I figured this out.

    This was working when tested in the QA enviornment.

    I was running the process from my local machine which had a different time zone compared with the one on QA m/c, that's why the issue.

    Yes, -05.00 in the data that tells about the time zone which is (GMT - 05.00)




    • Marked as answer by S Prashant Monday, May 27, 2013 9:30 AM
    • Edited by S Prashant Monday, May 27, 2013 9:34 AM
    Monday, May 27, 2013 9:30 AM