Hi all, When I am putting below statement in OLEDB Command Transformation...I am getting error.. But when i am executing in t-sql its working fine...Can anyone let me know whats the problem with this statement..? update t set t.bucket = ?, t.amountcollected = ? from transaction_tnx_test t inner join dbo.TRANSACTION_PAYEE_ASSOC_TPA_TEST tpa on t.id_tnx = tpa.id_tnx_tpa

what error you received exactly? and did you set input parameters ?http://www.rad.pasfu.com

Invalid Object name tvineesh1701

put whole statement in a stored procedure with input variables, and then just execute procedure like : exec mySP ? ,? ....http://www.rad.pasfu.com

I think the error message should be: Invalid object name 'transaction_tnx_test'. Could you check the connection, does it point to the right database? Anyway, the error message could be caused by: 1) The object that does not exist. 2) You should specify the owner of table. For more information, you can refer to: http://msdn.microsoft.com/en-us/library/aa258716(SQL.80).aspx Hope this helps, Raymond Raymond Li - MSFT