SQL Server Performance

DTSDataPumpTask

Discussion in 'SQL Server DTS-Related Questions' started by pab_mohan@rediffmail.com, Mar 6, 2006.

  1. 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.

Share This Page