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

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


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.

Thanks for your suggestion. Let me try it.

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