Hi All,

I have exported a DTS Package to a VB Module that contains an Analysis Server Process Cube Task. When I try to execute it in VB I get an object not defined error for "DTSOlapProcess.Task". I know I am missing a reference in VB but I cannot find the Library I am missing. Any help would be appreciated.

Thanks
John

In article <AF92DB3C-74FC-4976-B433-E537AB03BD4D (AT) microsoft (DOT) com>, JohnMcL
<wk1s (AT) aol (DOT) com> writes
The reference you need is DTSOlapProcess.

If you have trouble finding the reference check for the Dll.

SQL 2000
x:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll

SQL 7.0
x:\winnt\system32\DTSAddin.dll

You must have installed the AddIn (SQL 7.0) or the AS client (SQL 2000)
locally on you machine.


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

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

----- Darren Green wrote: ----

In article <AF92DB3C-74FC-4976-B433-E537AB03BD4D (AT) microsoft (DOT) com>, JohnMcL
<wk1s (AT) aol (DOT) com> write
The reference you need is DTSOlapProcess

If you have trouble finding the reference check for the Dll

SQL 200
x:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dl

SQL 7.
x:\winnt\system32\DTSAddin.dl

You must have installed the AddIn (SQL 7.0) or the AS client (SQL 2000)
locally on you machine


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

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


Thanks Darren

That was it.....it was even in the list but I guess I was looking for "Microsoft DTS........." something or other. Works like a charm now. Thanks again

Joh