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

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.

Hi @Phunya

Check this.

Hope this helps.

1 Like

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)

1 Like

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.