Post reply

Convert from unicodestring to uniqueidentifier in SSIS

  • October 6, 2015 at 1:47 am

    #321792

    Hi All,

    i want to Convert from unicodestring to uniqueidentifier.

    15D20B3C-50E5-43D4-A64F-BFEE0B8E11FA is in unicodestring and i need to convert thisvalue to uniqueidentifier

    Please help me.

    Thanks

    Rambabu

  • October 6, 2015 at 2:46 am

    #1831619

    maddukuru.rambabu (10/6/2015)

    Hi All,

    i want to Convert from unicodestring to uniqueidentifier.

    15D20B3C-50E5-43D4-A64F-BFEE0B8E11FA is in unicodestring and i need to convert thisvalue to uniqueidentifier

    Please help me.

    Thanks

    Rambabu

    Below statements are answer for above question.

    select cast('15D20B3C-50E5-43D4-A64F-BFEE0B8E55FA' as uniqueidentifier)

    select convert( uniqueidentifier ,'15D20B3C-50E5-43D4-A64F-BFEE0B8E55FA')

    If any alternative solution.then please let me know

    Thanks

  • October 6, 2015 at 3:21 am

    #1831629

    I notice you posted the question in the SSIS forum.

    If you have a read of this page:http://stackoverflow.com/questions/18876559/ssis-convert-string-to-a-guid-when-importing-and-saving-data it will show you how to do it in SSIS.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply