I have seen a lot of information on the web regarding executing a DTS package via a VB6 application. I tried all the tips I found with no success. Many hours of trial and error finally resulted in success.
These files/paths needed to be included in *MY* installation package:
[ProgramFiles]/Microsoft SQL Server/80/Tools/Binn
axscphst.dll
cdwtasks.dll
custtask.dll
dtsfile.dll
dtspkg.dll
dtspump.dll
dstwiz.dll
dtswiz.exe
semcomn.dll
semfsc.dll
sqlgui.dll
sqlns.dll
sqlresld.dll
sqlsvc.dll
w95scm.dll
[ProgramFiles]/Microsoft SQL Server/80/Tools/Binn/Resources/1033/
axscphst.rll
cdwtasks.rll
custtask.rll
dtsfile.rll
dtspkg.rll
dtspump.rll
dtswiz.rll
semcomn.rll
semfsc.rll
sqlgui.rll
sqlns.rll (no self register)
sqlsvc.rll
WINNT/System32/
sqlunirl.dll
I also included the MSDE re-distributable
This may or may not work for you... good luck!