OLE DB source

• miriyalasrihari

  Ten Centuries

  Points: 1225

  More actions

  January 19, 2011 at 6:19 am

  #233434

  in OleDb source --> connection manager

  how to connect to datamining services

  provider=?

  Datallinks=?

  server or file name=?

  location=?

  intial catalog=?

  [font="Verdana"]SRIHARI(:~[/font]

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 20, 2011 at 12:35 am

  #1275716

  You cannot connect to the data mining structure with an OLE DB source, you need an Analysis Services Connection Manager.

  See the following links:

  http://msdn.microsoft.com/en-us/library/ms141018.aspx

  http://msdn.microsoft.com/en-us/library/ms141728.aspx

  http://msdn.microsoft.com/en-us/library/ms139761.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP