I have created and scheduled a DTS pckage to populate data from ORACLE to SQL SERVER. This package runs fine but sometimes give following type of error. It doesn't give same error on re-run.

DTSStep_DTSDataPumpTask_3, Error = -2147467259 (80004005) Error string: Error at Destination for Row number 1574. Errors encountered so far in this task: 1. Error source: DTS Data Pump Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 3621 (E25) Error string: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 ... Process Exit Code 1. The step failed.

Please help. Thanks in advance.