Hi all, I have SSIS package which loads data from ORACLE (10g) into SQL Server 2008. After loading data I need to update processeddate in oracle table to sysdate. I try to use 'Execute SQL Task' in Control Flow and used simpe statement to update oracle table as ' UPDATE TABLE1 SET PROCESSED_DATE = SYSDATE WHERE PROCESSED_DATE IS NULL'. In debugging mode it doesn't give me an any error but the task doesnt get complete. It shows yellow color only and process still running for a long time. Can anyone help me here to understand the problem? Thanks

How many records are there and check if the task is stuck in pre-execute state in the progress tab if it is stuck there then wait for few minutes because if the table is loaded with huge data (specially oracle) the pre execute part takes time even we are facing the same problem and there isnt much that you can do. http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/35a484c7-4850-4f86-b14a-5dfb50491ab2/ -------------------------------------------------------- Surender Singh Bhadauria

In Execution Results Window: It says: Validation is completed. Warning: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

for the execute sql task what is it saying i mean the last message for that particular task -------------------------------------------------------- Surender Singh Bhadauria

There is no msg for execute sql task: it just shows start time only