DTS Redistribute/Install

[cable]

We have an Access/SQL Server solution, and the access db builds and runs a dts packadge. (The DTS package object library)

We need to deploy this to clients that do not have SQL server (and therefore the DTS components).

Does any one have an guide on how we can install the components?

We've tried regsvr'ing the dts*.dll's but we get missing entry point errors in sqlresld.dll (which was installed by sqlredis.exe (which I thought would install what i wanted))

 

[BukHix]

Can you program in VB.Net? Somewhere I have some code (instructions) that will run DTS packages on a client workstation from a VB application. Let me know if that will work you and I will look around for it.

 

[cable]

I've got the code running the package ok, it was installing the components needed for it to run.

Eventually I've found this:
To install client tools only for SQL Server 2000
1. Insert the Microsoft® SQL Server™ 2000 compact disc in your CD-ROM drive. If the compact disc does not autorun, double-click Autorun.exe in the root directory of the compact disc.

2. Select SQL Server 2000 Components, select Install Database Server, and then click Next at the Welcome screen of the SQL Server Installation Wizard.

3. In Computer Name dialog box, Local Computer is the default option, and the local computer name appears in the edit box. Click Next.

4. In the Installation Selection dialog box, click Create a new instance of SQL Server, or install Client Tools, and then click Next.

5. Follow the directions on the User Information, Software License Agreement, and related screens.

6. In the Installation Definition dialog box, click Client tools only, and then click Next.

7. In the Select Components dialog box, accept the defaults or select the components you want, and then click Next.
You can select an item in the Components list, such as Management Tools, and then select items from the related Sub-Components list, such as Enterprise Manager. Click to select items you want to install; clear the check box of the items you do not want to install.
For information about each component, select the item, and view the Description box.
8. In the Start Copying Files dialog box, click Next to complete the installation of the client tools.

Not a brilliantly simple solution but it works.

 

[ignas81]

Distributing the DTS dll's

How did you manage to do that ?

 

[cable]

How did you manage to do that ?

lots of hunting on the net basically!