I am using a merge statement to insert and update a view in DB2\linux view, for this we set up a linked server and for normal connections its working fine, but when I use merge statement in ssis its throwing the fallowing error
[Execute SQL Task] Error: Executing the query "SELECT [CUST_NBR]
,[CUST_CHRG_..." failed with the following error: "An unexpected token "DECLARE @tableVar TABLE
(MergeAction VARerface_1023_Archive)<concat>" was found following "". Expected tokens may include:
"". SQLSTATE: 42601, SQLCODE: -104". Possible failure reasons: Problems with the query, "ResultSet"
property not set correctly, parameters not set correctly, or connection not established correctly.
can you guys suggest me whether we can use merge statement on DB2\linux linked servers or not?
here the problem is with connection or what else?
View Complete Post