SQL Server Performance

DTS problem

Discussion in 'SQL Server DTS-Related Questions' started by ChrisSCLee, Apr 9, 2003.

  1. ChrisSCLee New Member

    Wonder if anyone could give me hint? Thanks.

    I tried to use DTS to import data from Sybase Anywhere to MS SQL 7 server. I was able to execute the DTS job manually from my workstation successfully. However, when I scheduled and ran the same job, it dailed. The error I got:

    "... DTSRun: Executing... DTSRun OnStart: Delete from Table [Datawarehouse_Integration].[dbo].[INVC] Step DTSRun OnFinish: Delete from Table [Datawarehouse_Integration].[dbo].[INVC] Step DTSRun OnStart: Copy Data from Results to [Datawarehouse_Integration].[dbo].[INVC] Step DTSRun OnError: Copy Data from Results to [Datawarehouse_Integration].[dbo].[INVC] Step, Error = -2147220470 (8004040A) Error string: Data Source Object name or SQL Statement is required to obtain a Rowset. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147220470 (8004040A); Provider Error: 0 (0) Error string: Data Source Object name or SQL Statement is required to obtain a Rowset. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 DTSRun OnFinish: Copy Data from Results ... Process Exit Code 1. The step failed."

    Chris
  2. satya Moderator

    Make sure SQLAgent have all necessary privileges to carry on the DTS package when you schedule.
    Try running PROFILER while running this process and see where it fails. You can get information about what object or SQL statment its looking for.

    _________
    Satya SKJ

Share This Page