Hi,

Issue: I created a VB6 app with DTS code in a module. I
then created an .MSI script to install this application on
other computers.

The problem: When I tested my install application on
another computer with SQL Server 2000 already installed,
their DTS Designer Window lost all the icons for each
individual task. The tasks still work, but they are much
harder to 'read' without the proper icons...

MSI includes the following:

dtspkg.dll
dtspkg.rll

AND

DTS1033 Merge Module

I'm guessing that the *.dlls were re-registered on the
target machine and the resources connecting the icons were
not included.

Anyone have advice for me?

Thanks in advance,
ben

The DTSui.dll contains the icons. You might want to include that in your
application.

Rand

Rand, can you include DTSUi in an application as it is not covered by the
Redist agreement.

Ben,

Make sure you have got all the Dlls and Rlls included in the DTS section of
Redist.txt or here-

Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)

Also check out this post-

http://tinyurl.com/qac7


-
Darren Green
http://www.sqldts.com

"Rand Boyd [MS]" <rboyd (AT) onlinemicrosoft (DOT) com> wrote

You have a point Darren. I was picking up on the fact that they already had
Enterprise Manager installed so was not focusing on the redist situation.
The problem may be related to the level of the service pack that the user
is on compared to version of the dlls that are shipped with the application.

Rand
This posting is provided "as is" with no warranties and confers no rights.

....thanks...
Installing my app on computers w/out sql server is fine
(nothing to fudge up in dts gui environment); the problem
occurs when using my MSI to install on a computer that
already has sql server 2000 installed. It is these
computers (including the one that created the msi) that
loose the dts icons in the dts environment.

How to: get those icons back? The vb app and the msi
Wise app were all created on one computer (also the
source of the dts .dlls and .rlls .... I then
(foolishly) tested my msi script on my own computer not
knowing some com issues would creap in (ocx's being re-
registered...losing my dts icons...)

I don't think it's a service pack issue since everything
started and ended on the same pc!

Anyways, it's a small vb app, and I'm assuming 99% of
target computers will NOT have SQL Server installed.

thanks again,
ben
bsierad (AT) dsgllc (DOT) com

The icons may be missing because of the dtspkg.dll was re-registered and
the dtsui.dll has not been re-registered. The normal order is dtspkg.dll
then dtsui.dll. You may be able to get the icons back by re-registering the
dtsui.dll.

Your lkast post said the following:

I don't think it's a service pack issue since everything started and ended
on the same pc!

Was the dtspkg.dll that you included with the application the one that came
off of the CD or the one from the service package installation files that
is currently installed on the pc.

This posting is provided "as is" with no warranties and confers no rights.

Thank You

I simply ran
regsvr32.exe dtsui.dll and restarted EM