DTS package error

[captainmorgan1]

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

 

[EdwinGene]

It looks like your source text file is missing, or misnamed, or the path the text file is put in is changed, somehow.

Anyway, I would suggest you start there.