Am Getting "Insert: Incorrect syntax near '-' " while running insert activity. Please help

[Nancy29 (Dropoffhoney29)]

Hi All,

I am using extract datatable activity to get the table column and row details from web application and it needs to insert into the SQL database table. while running insert activity, I am getting "Insert: Incorrect syntax near ‘-’ " error. One data column value contains “-” symbol (AccNo is abc-123) .

Attri type is ‘Text’ in metadata and table setting. Should I need to change it.

Could you please help to solve this error.Thanks

[sarathi125 (Parthasarathi)]

@Nancy29,

If you AccNo column in database is VarChar then it should allow you to enter the Hyphen, try to enclose the value with Single quotes and try.

[Nancy29 (Dropoffhoney29)]

Thanks for your suggestion. Let me try it.