I'm running a dts package from an ACCESS2000 ADP with the following code

Dim dtsp As New DTS.Package
dtsp.LoadFromSQLServer _
ServerName:="xxfs001", _
ServerUserName:="sa", _
ServerPassword:="xyzsde", _
PackageName:="DTSprojectimport"
dtsp.Execute

I'm unable to run the same package from an other workstation that has the
ADP local using ACCESS 97. Is it because it doesn't have SQL enterprise
installed ? or is it because of the access version or Both ? how can I
resolve that I tried to registered DTSPKG.dll using regsvr32 on the target
workstation but it fail saying "the specified process is not found"
(translation from french)

thanks for your help

FRED

OK you will need more than just that dll

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"FRED" <FRED (AT) discussions (DOT) microsoft.com> wrote