captainmorgan1
Technical User
Our operating system is Windows 2000 Server, we use SQL 7.
Our DTS package (Transfer ADS) transfers information from text files and puts it into SQL 7 so our Clients program can access it. It was working fine, now when I run it, it fails at the first DTSDataPumpTask and I don't know why. Here is the error:
------------------------------------------------------------
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description
ata Source Object name or SQL Statement is required to obtain a Rowset. (Microsoft OLE DB Provider for SQL Server (800040e37): Table does not exist.)
Step Error code: 8004040A
Step Error Help File:sqldts.hlp
Step Error Help Context ID:1100
------------------------------------------------------------
Any help on this would be greatly appreciated. Or, if you could tell me where to get the help I need I would be grateful.
Our DTS package (Transfer ADS) transfers information from text files and puts it into SQL 7 so our Clients program can access it. It was working fine, now when I run it, it fails at the first DTSDataPumpTask and I don't know why. Here is the error:
------------------------------------------------------------
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description
ata Source Object name or SQL Statement is required to obtain a Rowset. (Microsoft OLE DB Provider for SQL Server (800040e37): Table does not exist.)Step Error code: 8004040A
Step Error Help File:sqldts.hlp
Step Error Help Context ID:1100
------------------------------------------------------------
Any help on this would be greatly appreciated. Or, if you could tell me where to get the help I need I would be grateful.
