Hi, This is wiered problem I am facing when I execute a DTS package to fetch the information of oracle database to sql server database. The job was working fine earlier.
this is what the error looks like:
DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147008507 (80074005)
Error string: Unspecified error Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts.hlp Help
context: 1100 Error Detail Records: Error: -2147008507
(80074005); Provider Error: 0 (0) Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp Help context: 1100 Error: -2147467259
(80004005); Provider Error: 0 (0) Error string: Timeout expired
Error source: Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun
OnError: D... Process Exit Code 2. The step failed.

One more thing, I created the same type to package to transfer the contents to a text file for testing, the package executes in one system and does not executes in the current system.