missing Tasks
bill
Porcessing task or a Data Mining Prediction Task. The task icons just
are not there. But I can open and edit a dts package containing an
analysis services task.
What's going on? The machine is Win2000 sp2. This is with and and
without SQL2K SP2. This is also with and without SP2 for analysis
services. This happens after cleaning up the install and deleting all
of BINN. I saw Q317059, but that doesn't seem to help. I had MDAC 2.7
at one time, but I have since installed 2.6. Also I have completely
uninstalled MDAC and reinstalled SQL2K. No change. There are cubes
present. msmdsrv runs OK. So does SQL2K
Hints please.
Bill
Darren Green
Designer. The task DLL is -
x:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll
Use the register Custom Task option from the Tasks menu in the designer.
Task Description - Analysis Services Processing Task
Task location - See DLL above
Icon location - See DLL above
--
Darren Green (SQL Server MVP)
http://www.sqldts.com
Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm
"bill" <rcair...@hotmail.com> wrote in message
news:b23d3de.02101...@posting.google.com...
bill
> Try manually re-registering the Analysis Services Processing Task in the DTS
> Designer. The task DLL is -
> x:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll
Ding! Give the man a cigar. That worked. Thanks.
To register the task - When you select the dll, the icon location gets
populated with the dll name. According to BOL, the dll usually holds
the icon.
I was missing both Data Mining Prediction and Analysis Services
Processing Tasks. So I registered msmdtsp.dll and msmdtsm.dll as
custom tasks. The add-in packages for SQL 7 will not help.
Reinstalling SQL2K, analysis services, or the services packs did not
help either.
Also, thank you for your website.
Bill