December 27, 2001 at 9:25 am
Does anyone know how I can connect to Analysis services from the DTS designer?
December 27, 2001 at 11:32 am
If you are looking to do processing, there is an Analysis Services Processing Task. So far as an icon is concerned, it's shaped like a cube.
If you are looking to connect to it as a data source, you always have the option of selecting Other Connection (Globe in front of a Window). There you can select to use the OLE DB Provider for OLAP Services (you may have 2 versions, one specifically for 8.0). The Data Source should be the server name and the rest is self-explanatory.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
Edited by - bkelley on 12/27/2001 11:32:49 AM
K. Brian Kelley
@kbriankelley
December 27, 2001 at 12:40 pm
Thanks I really appreciate it. I am however getting an error. "BindMoniker Failed" Unspecified error. This happens when I try to create the OLAP connection. I believe this is because of the OLE. Have you seen this before?
Thanks
If you are looking to do processing, there is an Analysis Services Processing Task. So far as an icon is concerned, it's shaped like a cube.
If you are looking to connect to it as a data source, you always have the option of selecting Other Connection (Globe in front of a Window). There you can select to use the OLE DB Provider for OLAP Services (you may have 2 versions, one specifically for 8.0). The Data Source should be the server name and the rest is self-explanatory.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
Edited by - bkelley on 12/27/2001 11:32:49 AM
[/quote]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply