Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to run DTS packages on sql-server

Status
Not open for further replies.

chrissie1

Programmer
Aug 12, 2002
4,517
BE
i have local packages on my sql-server 2000 and want to run them from within access but i seem to run into some trouble.
Is their anybody out there that has done this already? and how?
I tried this (not the exact code

docmd.runsql "EXEC master..xp_cmdshell ('dtsrun /Sserver /Npackage /E')"

and this

Dim oPKG As New DTS.Package
oPKG.LoadFromSQLServer "MyServer", , , _
DTSSQLStgFlag_UseTrustedConnection, , , , "MyPackage"
oPKG.Execute
oPKG.UnInitialize
Set oPKG = Nothing

thanks in advance for any help "What a wonderfull world" - Louis armstrong
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top