Convert from unicodestring to uniqueidentifier in SSIS

• maddukuru.rambabu

  Right there with Babe

  Points: 722

  More actions

  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

• maddukuru.rambabu

  Right there with Babe

  Points: 722

  More actions

  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

• Neil Burton

  SSC-Insane

  Points: 23073

  More actions

  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