Getting warning in Update query
Posted: Thu May 10, 2007 1:02 am
Hi,
I want to update the data in SQL Server table, for that I have taken a job design as Sequentialfile(dummy)-->Transformer-->ODBC stage.
In Sequential file I have taken some dummy data and passing it into transformer stage and finally I have taken the update query in ODBC stage. when I run this job records getting updated but I am getting below warning
STG_SVC_MRCHNT_HEADER_UPDATE_PROCESS..trnPassThru.updateTgtTable: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE
STG_SVC_MRCHNT_HEADER_INBOUND
SET INTF_STATUS = 'PROCESS'
WHERE INTF_STATUS IN ('IN_PROCESS')
0 Rows affected.
dummy = 1
Please let me know what might be the reason and how can I eliminate this warning.
Regards
Sridhar
I want to update the data in SQL Server table, for that I have taken a job design as Sequentialfile(dummy)-->Transformer-->ODBC stage.
In Sequential file I have taken some dummy data and passing it into transformer stage and finally I have taken the update query in ODBC stage. when I run this job records getting updated but I am getting below warning
STG_SVC_MRCHNT_HEADER_UPDATE_PROCESS..trnPassThru.updateTgtTable: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE
STG_SVC_MRCHNT_HEADER_INBOUND
SET INTF_STATUS = 'PROCESS'
WHERE INTF_STATUS IN ('IN_PROCESS')
0 Rows affected.
dummy = 1
Please let me know what might be the reason and how can I eliminate this warning.
Regards
Sridhar