DTS problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS problem

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

]]>