Found this neat but of code in a previous posting which I've used within an Access ADP Project. I have SQL server installed and the code works fine. When given to a user without SQL Server, the second line fails. Presumably it's something to do with the DTSPackage Object Library (dtspkg.dll) being missing. Does the whole of SQL Server have to be installed to use this or is there another process that has the same effect. Tried copying dtspkg.dll locally but no luck

Any help much appreciated

Thank

Nei

All credit to Darren Green for www.sqldts.co


Private Sub SimpleExecutePackage(
Dim oPKG As New DTS.Packag
oPKG.LoadFromSQLServer "MyServer", , ,
DTSSQLStgFlag_UseTrustedConnection, , , , "MyPackage
oPKG.Execut
oPKG.UnInitializ
Set oPKG = Nothin
End Su

No you do not need to install the whole of SQL Server

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

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

When given to a user without SQL Server, the second line fails. Presumably
it's something to do with the DTSPackage Object Library (dtspkg.dll) being
missing. Does the whole of SQL Server have to be installed to use this or
is there another process that has the same effect. Tried copying dtspkg.dll
locally but no luck.

Allan

Many thanks for that.

I've tried registering dtspkg.dll using a command based on the following from the link you sent me.

Regsvr32.exe "X:\Program Files\ApplicationDirectory\dtsffile.dll"

When I run it though, I get the message

LoadLibrary("dtspkg.dll") failed - The specified module could not be found.

Any ideas?

Thanks again


Neil

Never had this. Are all your other files in place?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

In message <A825C222-E1D0-4A95-8F8B-6354E6360603 (AT) microsoft (DOT) com>, Neil
<anonymous (AT) discussions (DOT) microsoft.com> writes

Do you really have a file on your X drive called Program
Files\ApplicationDirectory ?

X:\Program Files\ApplicationDirectory\dtsffile.dll is just a sample
path. You need to copy the files listed, including the resource files
which need to be in the sub directory as indicated, to your own machine,
then set that path as the regsvr32 command.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org