Hi Al

I have built a DTS Package that updates some SQL Tables and then Processes an Analysis server Cube. I want to execute this from a client PC under the control of VB. I have built the VB program using the LoadFromSQLServer method and it works great from my PC . When I installed it on the client PC (after building a package) and trying to run the program I get the following
Run time error 42
ActiveX component can't create object

The only object it would be trying to create is the Package object and I thought the necessary .DLLs were included in the package install (dtspkg.dll, custtask.dll, msmdtsp.dll). The error would lead me to believe that the PC needs some part of SQL 2000 installed on it as well. I also tried the other method --- saving the DTS package as a VB file, that worked on my PC as well but I like the LoadFromSQLServer method better. Besides I got the same error on the client with the .Bas method

I tried installing the Client Components of SQL Server on the PC but I still get the same error. Does anyone know what I am missing. I have not got to the Analysis server piece yet...am I going to need something installed on the client PC for that also. I would like to keep the client as thin as possible and only install what I actually need.

Any comments would be appreciated

Thank
John

You need the DTS dlls.

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

you will also need the Olap Task which is

msmdtsp.dll

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"JohnMcL" <wk1s (AT) aol (DOT) com> wrote

control of VB. I have built the VB program using the LoadFromSQLServer
method and it works great from my PC . When I installed it on the client PC
(after building a package) and trying to run the program I get the
following:
(dtspkg.dll, custtask.dll, msmdtsp.dll). The error would lead me to believe
that the PC needs some part of SQL 2000 installed on it as well. I also
tried the other method --- saving the DTS package as a VB file, that worked
on my PC as well but I like the LoadFromSQLServer method better. Besides I
got the same error on the client with the .Bas method.
got to the Analysis server piece yet...am I going to need something
installed on the client PC for that also. I would like to keep the client
as thin as possible and only install what I actually need.

Thanks Allan-----That was a great help and it also pointed me to the redist.txt file for SQL....I actually need a little more for OLAP since the task is PROCESSING the cube but I think I have it all now. However I am still getting an error when the VB program Loads the Package from the Server. The SQL tasks are working now but when it tries to load the OLAP task I get an error that it "Can't find msmdso.rll in c:\WINNT\system32\resources\1033". I tried putting it there but I still get the error. According to redist.txt it should be put in "....Program Files\Common Files\Microsoft Shared\DSO\Resources\1033". It appears that I am getting a false error

When the package executes, the SQL tasks are OK and when it executes the OLAP task I get an error that the "ActiveX component cannot load an object", probably due to the previous error which I cannot figure out what it is telling me

Have any ideas????

Thank
John McLaughlin

Have you installed Analysis server on the box on which this package runs ?
Is this 2000 or 7
Make sure the task and all connecting to it in the workflow properties
"Execute on Main Package thread"


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"JohnMcL" <wk1s (AT) aol (DOT) com> wrote

task is PROCESSING the cube but I think I have it all now. However I am
still getting an error when the VB program Loads the Package from the
Server. The SQL tasks are working now but when it tries to load the OLAP
task I get an error that it "Can't find msmdso.rll in
c:\WINNT\system32\resources\1033". I tried putting it there but I still get
the error. According to redist.txt it should be put in "....Program
Files\Common Files\Microsoft Shared\DSO\Resources\1033". It appears that I
am getting a false error.
probably due to the previous error which I cannot figure out what it is
telling me.

Hi Allen

Just thought I would let you know the resolution to the problem.....

I loaded just Analysis Server, Client Components and DSO on the system and ran my program..... I still got the error that it "Can't find msmdso.rll in c:\WINNT\system32\resources\1033". However, this time I not only got it when it loaded the package from the server but when it tried to execute the step as well. I got the message multiple, multiple times and just kept replying OK to the error and it kept on executing...i think making a little progress each time.....it finally got to the point that it kept giving me the error all the time (I think it was giving me the error for every record it was processing). I canceled the process but I never did receive the error that it could not load an Object......progress????

I next tried to load Analysis Server, ANALYSIS MANAGER, Client Components and DSO....then SP3a....then my Program again (I still include DTS, DMO, DSO, etc..... a copy of my Setup.lst follows FYI) That did it.....no more errors and my program runs just great now.

Thanks for your help

setup.lst per redist.txt
[Bootstrap
SetupTitle=Instal
SetupText=Copying Files, please stand by
CabFile=RunDTSPackage.CA
Spawn=Setup1.ex
Uninstal=st6unst.ex
TmpDir=msftqws.pd
Cabs=

[Bootstrap Files
File1=@VB6STKIT.DLL,$(WinSysPathSysFile),,,7/15/00 12:00:00 AM,101888,6.0.84.5
File2=@COMCAT.DLL,$(WinSysPathSysFile),$(DLLSelfRe gister),,5/31/98 12:00:00 AM,22288,4.71.1460.
File3=@STDOLE2.TLB,$(WinSysPathSysFile),$(TLBRegis ter),,6/3/99 12:00:00 AM,17920,2.40.4275.
File4=@ASYCFILT.DLL,$(WinSysPathSysFile),,,3/8/99 12:00:00 AM,147728,2.40.4275.
File5=@OLEPRO32.DLL,$(WinSysPathSysFile),$(DLLSelf Register),,3/8/99 12:00:00 AM,164112,5.0.4275.
File6=@OLEAUT32.DLL,$(WinSysPathSysFile),$(DLLSelf Register),,4/12/00 12:00:00 AM,598288,2.40.4275.
File7=@msvbvm60.dll,$(WinSysPathSysFile),$(DLLSelf Register),,8/23/01 7:00:00 AM,1388544,6.0.92.3

[IconGroups
Group0=Run DTS Packag
PrivateGroup0=-
Parent0=$(Programs

[Run DTS Package
Icon1="RunDTSPackage.exe
Title1=Run DTS Packag
StartIn1=$(AppPath

[Setup
Title=Run DTS Packag
DefaultDir=$(ProgramFiles)\Run DTS PackageAppExe=RunDTSPackage.ex
AppToUninstall=RunDTSPackage.ex

[Setup1 Files
File1=@msmdso.rll,$(CommonFiles)\Microsoft Shared\DSO\Resources\1033\,,$(Shared),12/17/02 6:09:20 PM,125624,8.0.760.
File2=@custtask.rll,$(AppPath)\Resources\1033\,,,4 /17/01 11:21:50 PM,65536,2000.80.382.
File3=@sqldmo.rll,$(AppPath)\Resources\1033\,,,12/17/02 5:22:44 PM,585728,2000.80.760.
File4=@sqlsvc.rll,$(AppPath)\Resources\1033\,,,8/6/00 12:50:36 AM,24576,2000.80.194.
File5=@sqlsvc.dll,$(AppPath),,,12/17/02 5:25:38 PM,94784,2000.80.760.
File6=@sqldmo.dll,$(AppPath),$(DLLSelfRegister),,1 2/17/02 5:25:22 PM,4215360,2000.80.760.
File7=@sqldmo80.hlp,$(AppPath),,,7/13/00 9:17:32 AM,2101214,0.0.0.
File8=@sqldmo80.cnt,$(AppPath),,,7/13/00 9:13:32 AM,84938,0.0.0.
File9=@w95scm.dll,$(AppPath),,,12/17/02 5:25:54 PM,49728,2000.80.760.
File10=@sqlunirl.dll,$(WinSysPath),,,10/2/02 3:32:28 PM,180800,2000.80.728.
File11=@dtspump.rll,$(AppPath)\Resources\1033\,,,8 /6/00 12:50:34 AM,102400,2000.80.194.
File12=@dtspkg.rll,$(AppPath)\Resources\1033\,,,12 /17/02 5:22:42 PM,208896,2000.80.760.
File13=@dtsffile.rll,$(AppPath)\Resources\1033\,,, 8/6/00 12:50:34 AM,28672,2000.80.194.
File14=@axscphst.rll,$(AppPath)\Resources\1033\,,, 8/6/00 12:50:34 AM,28672,2000.80.194.
File15=@dtsrun.rll,$(AppPath)\Resources\1033\,,,8/6/00 12:50:34 AM,24576,2000.80.194.
File16=@axscphst.dll,$(AppPath),$(DLLSelfRegister) ,,8/6/00 12:50:46 AM,57410,2000.80.194.
File17=@sqlresld.dll,$(AppPath),,,12/17/02 5:25:32 PM,29248,2000.80.382.
File18=@dtsrun.exe,$(AppPath),,,12/17/02 5:23:10 PM,41536,2000.80.534.
File19=@dtspump.dll,$(AppPath),$(DLLSelfRegister), ,12/17/02 5:23:58 PM,528960,2000.80.760.
File20=@dtsffile.dll,$(AppPath),$(DLLSelfRegister) ,,12/17/02 5:23:56 PM,119360,2000.80.760.
File21=@msmdnet.dll,$(CommonFiles)\Microsoft Shared\DSO\,$(DLLSelfRegister),$(Shared),12/17/02 4:24:28 PM,44192,8.0.382.
File22=@msmdlock.dll,$(CommonFiles)\Microsoft Shared\DSO\,$(DLLSelfRegister),$(Shared),12/17/02 4:24:26 PM,44184,8.0.382.
File23=@msmddo.dll,$(CommonFiles)\Microsoft Shared\DSO\,$(DLLSelfRegister),$(Shared),12/17/02 6:09:06 PM,2964072,8.0.0.760
File24=@msmddo80.dll,$(CommonFiles)\Microsoft Shared\DSO\,$(DLLSelfRegister),$(Shared),12/17/02 6:09:10 PM,4062384,8.0.0.760
File25=@dtspkg.dll,$(AppPath),$(DLLSelfRegister),, 12/17/02 5:23:58 PM,1905216,2000.80.760.0
File26=@custtask.dll,$(AppPath),$(DLLSelfRegister) ,,12/17/02 5:23:52 PM,315968,2000.80.760.0
File27=@msmdtsp.dll,$(WinSysPath),$(DLLSelfRegiste r),$(Shared),12/17/02 4:24:34 PM,369232,8.0.0.760
File28=@RunDTSPackage.exe,$(AppPath),,,1/9/04 3:04:15 PM,28672,1.0.0.0
<<<<<

John McLaughlin
Sean Christopher Associates
wk1s (AT) aol (DOT) com