Hi

I am struggling to get a working SQL 7 DTS package for exporting data
to ms access, to be deployed on machines running MSDE 1.0.

When I run my VB program to execute my package, I get the following
error:

"The Microsoft Jet Engine cannot find the input table or query XXX.
Make sure it exists and that its name is spelled correctly"

After some investigation, it seemed to me that I dont have any create
steps!

The following:

Dim oPkg As New DTS.Package

oPkg.LoadFromStorageFile App.Path & "\ExportMSaccess.dts",
"welkom"

Dim i As Integer
For i = 1 To oPkg.Steps.Count
MsgBox oPkg.Steps(i).Name
Next i

provides me a list of steps, but it contains only the copy steps!

Copy Data from XXX to XXX Step
Copy Data from YYY to YYY Step
.......

However, when I create a SQL 2000 version of my package, the list of
steps is as follows:

Create Table XXX Step
Copy Data from XXX to XXX Step
Create Table YYY Step
Copy Data from YYY to YYY Step
.......

The SQL 2000 package works fine.

What could be wrong here?


Best regards,
Hugo Faber