Error insert GUID to MSSQL(Microsoft SQL Server Management Studio)

[Phunya (Harpoon)]

i use read range data from Excel sheet and in excel datatype of coloumn is General
and I use activities Run command for insert datatable to database
and then i got this error “Failed to convert parameter value from a String to a Guid.”

• data type guid in database is uniqueidentifier
  How can i fix this error.

[Suraj_B_Shetty (Suraj)]

Hi @Phunya

Check this.

How to convert a String to Guid in dataservice

Hi team, I’m getting the record id in string format but when I try to pass it to ‘Get record by ID’ activity its showing formatting error. How do I parse string to GUID format.

Hope this helps.

[postwick (Paul)]

You have a column in your database that is datatype GUID but in your datatable it’s String. You have to make your datatable column the same GUID datatype (system.guid)

[raja.arslankhan (Raja Muhammad Arslan khan)]

@Phunya
One of columns in your database datatype is Guid. You need to convert value from string to sqlguid