Does anyone have a way to install both a DTS package and/or a DTS Custom
Task via InnoSetup?

DavidM wrote:
I don't know InnoSetup, but for installing a custom task you must register
your customtask-dll by regsvr32 and write the necessarily registry values.

Example:
p.s. the 93B5C1C3-EF97-4202-B65E-E5D6A3109755
is the clsid from the vb6-dll....edit only this!


Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}]
@="MyTask.MyClassINVB6DLL"
"AppID"="{93B5C1C3-EF97-4202-B65E-E5D6A3109755}"
"DTSIconFile"="C:\\VB6_projekte\\LoadCube\\DLL\\My Task.dll"
"DTSIconIndex"=dword:00000000
"DTSTaskDescription"="MyCoolTask"

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\Implemented
Categories]

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\Implemented
Categories\{10020200-EB1C-11CF-AE6E-00AA004A34D5}]

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\Implemented
Categories\{40FC6ED5-2438-11CF-A3DB-080036F12502}]

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\InprocServer
32]
@="C:\\VB6_projekte\\LoadCube\\DLL\\MyTask.dll"
"ThreadingModel"="Apartment"

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\ProgID]
@="MyTask.MyClassINVB6DLL"

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\Programmable
]

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\TypeLib]
@="{1C8FA308-4082-47BC-A8A8-AB1F87F5E361}"

[HKEY_CLASSES_ROOT\CLSID\{93B5C1C3-EF97-4202-B65E-E5D6A3109755}\VERSION]
@="1.0"

You can insert the values silent by regedit /s through the setup.
If you start the sql-mmc after the setup..the custom task will appear in the
DTS-designer

regards

frank

This is what I wanted -- thanks!

I was opening that Darren Green (from sqldts.com) would reply and tell me
how he did it for the tasks on his site. And, if he is using Inno, let me
see is .iss script. Oh well.

Thanks again




"Frank Matthiesen" <fm (AT) xax (DOT) de> wrote

In message <e0RqA3A9EHA.3676 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, DavidM
<spam (AT) spam (DOT) net> writes
I use VSI, and just added a load of reg entries, pretty much those Frank
has listed. Never used Inno setup, but I started looking at it to try
and reply, and may use it in the future . I think it has a way to add
reg values, then you could do this in there, or use a reg file as per
Frank's reply. Perhaps the benefit of doing it as part of the setup is
that they will be un-installed cleanly as well.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Yes, it does have a way to add registry values and uninstall. I was just
not sure what registry values to add.

Thanks


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote