VB.net/SQL Server DTS

G

Guest

Hello Al

I have written a vb.net application that calls a DTS package created in sql server. The problem i am having is with my application build. When i install it on another PC the DTS package will not execute. I have had this problem before and once i install SQL Server Enterprise manger on the target machine it works. I would like to find a work around so that i can include the necessary files in my build. I have included the dtspkg.dll in my build but have not done anything with the properties. One of my suspicions is that i do not have these settings properly set. Any ideas or references would be a big help

Thanks in advance
BA
 
A

Andy Ball

you need these files as per below - this is from the Redist.txt from the
root of the SQL Server CD

Data Transformation Services (DTS)
----------------------------------------------
File Name Description
----------------------------------------------
sqlresld.dll Satellite Resource DLL Loader
dtsffile.dll DTS Flat File OLE DB Provider
dtsffile.rll DTS Resource File
dtspkg.dll DTS Package
dtspkg.rll DTS Resource File
dtspump.dll DTS Datapump
dtspump.rll DTS Resource File
axscphst.dll DTS ActiveX Script Host
axscphst.rll DTS Resource File
dtsrun.exe Command Line Utility to Execute a DTS Package
dtsrun.rll DTS Resource File
sqlunirl.dll SQL Server Unicode/ANSI Translation Layer
custtask.dll DTS Custom Tasks File
custtask.rll DTS Custom Tasks Resource File






BA said:
Hello All

I have written a vb.net application that calls a DTS package created in
sql server. The problem i am having is with my application build. When i
install it on another PC the DTS package will not execute. I have had this
problem before and once i install SQL Server Enterprise manger on the target
machine it works. I would like to find a work around so that i can include
the necessary files in my build. I have included the dtspkg.dll in my build
but have not done anything with the properties. One of my suspicions is
that i do not have these settings properly set. Any ideas or references
would be a big help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top