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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 7 DTS "dtspkg.dll"

Status
Not open for further replies.

vbSun

Programmer
Dec 9, 2002
504
US
I am trying to deploy an application which uses dtspkg.dll to run some DTS packages. I had packaged the app trying both SQL Server 7 and SQL Server 2000. The deployment is happening in an XP workstation. The program acts as a client to fire off some DTS packages on user request.

But, the installation fails because it fails to register the dtspkg.dll. When the user runs the application, it shouts "Create Object failed!". Any other dependencies for this file? In other words, what should i do to get the deployment working?

All help appreciated.

Thanks!

------------------------------------------
The faulty interface lies between the chair and the keyboard.
 
For those who have not found it yet, the files that are required are,

sqlresld.dll
dtsffile.dll
dtsffile.rll
dtspkg.dll
dtspkg.rll
dtspump.dll
dtspump.rll
axscphst.dll
axscphst.rll
dtsrun.exe
dtsrun.rll

Additionally,
for SQL Server 2000
custtask.dll
custtask.rll
sqlunirl.dll

and for SQL Server 7.0
sqlwoa.dll
sqlwid.dll

You need to manually include all these dlls and register
dtsffile.dll, dtspkg.dll, dtspump.dll, axscphst.dll and
custtask.dll.

Hope it helps someone..

------------------------------------------
The faulty interface lies between the chair and the keyboard.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top