Then I made the target update action as "User-Defined Sql' and i wrote my target sql as
Code: Select all
UPDATE tempdb.dbo.tbltst SET empname=:2 WHERE empid= :1;
Code: Select all
MultJob..Transformer_14: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'.
MultJob..Transformer_14: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
Code: Select all
UPDATE tempdb.dbo.tbltst SET empname=? WHERE empid= ?;
What is wrong in my first statement?
And in some other posts, it is mentioned we can dynamically give the column names to the user defined sql? how to acheive this functionality?