Batch job is failing RRS feed

  • Question

  • Hi all

    One batch job named allicationame_batch_synk is running fine for more tha 5 years. For the past 5 days the job is failing by giving the following error message..Current version of MS Sql we are using is Sql Server 2000. This job is running between Oracle 9i and Sql Server 2000.

    DTSRun OnError:  DTSStep_DTSExecuteSQLTask_8<c/> Error = -2147217900 (80040E14)      Error string:  OLE DB provider 'MSDAORA' could not delete from table 'select * from gcr_itplan_project_updates where 1=1'. The rowset was using optimistic c...  Process Exit Code 1.  The step failed.,00:00:13,0,0,,,,0

    Its very urgent for my project...please do reply fast...

    • Moved by Kenneth Lee Wednesday, April 20, 2011 8:00 AM forum cleanup (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    Tuesday, September 21, 2010 2:52 PM