Avatar

Level 2

Hi,

 

In update data activity, I'm getting below error:

ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Argument data type smallint is invalid for argument 1 of substring function. SQLState: 37000

 

Here source field has short datatype and destination has string datatype.

Using ToString(), I tried to convert short to string but its not working.

 

Please let me know how to resolved the issue.

 

Thanks