Hi,

Using SQL 2000 I have created a DTS package (saved to a structured
storage file) for the export of data to MS Access. In a small VB
program, the package is loaded and the destination file of the ms
access file is changed into a file name which will be passed by an
application. In SQL 2000 this works fine.

Hoewever, the application will be deployed together with MSDE 1.0.
Therefore I have asked someone else to create a SQL7 DTS package for
my database. I have tested this package on the MSDE machine using
dtsrun.

My first try gave me a incorrect parameter error. After some research,
it seemed that this error may be caused by package incompatibility
problems, so the SQL7 DTS package has been created again, but has now
been supplied with a password. This makes sense! Dtsrun loops through
all my steps... however, when the 'copy' steps have be executed, I get
the following error

Provider Error: 17 (11) Error string:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

I am using the following command

dtsrun /Fexportmsaccess.dts /Mxxx

It seems that there are still some package compatibility/portability
problems. Can some explain me what may be changed to the package to be
able to run it on the MSDE machine?

Thanks and best regards,
Hugo Faber