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