Including DTS in a VB program installer

• Sarah Dutkiewicz

  SSCommitted

  Points: 1870

  More actions

  August 10, 2004 at 7:29 am

  #66522

  I have a VB program that calls a DTS package to import data from a text file into a database for reporting.  The DTS package works wonderfully.  The problem I'm running into though is creating an installer for my app with the right DTS files.

  I'm using VB 6 and the DTS packages (2 different ones) live on SQL Server 2000.  When I test my VB app on a PC that has the SQL client tools installed, the app works wonderfully and as planned.

  When I test my VB app on a PC that doesn't have the SQL client tools installed, it gives me a runtime error 429, where Active X cannot create the object.

  Here are the files I've included in my project:

  axscphst.dll/.rll

  dtsffile.dll/.rll

  dtspkg.dll/.rll

  dtspump.dll/.rll

  sqlresld.dll

  dtsrun.exe

  dtsrun.rll

  sqlwoa.dll

  sqlwid.dll

  I've tried placing them in the System32 directory and in the application directory, and the DTS part still fails.

  Is this the right place to post this?  Anyone ever run into this before and know how to get this to work, outside of installing the SQL client tools?

  Thanks in advance!

• Tom Hamilton-126456

  Mr or Mrs. 500

  Points: 527

  More actions

  August 11, 2004 at 8:35 am

  #518505

  Hi Sarah,

  Here's a link that describes what you / how you need to proceed. 

  http://www.sqldts.com/default.aspx?225

  hth