Configuring ole db provider for Indexing Service

Hi:

Am trying to access a Indexing Services catalog from SSIS. Problem is configuring the Data Connection.

I chose New Connection, Provider=Microsoft OleDB provider for Indexing Services.

Then I am not quite sure what to fill in for:

A. Server or File Name (I tried the IP address, the machine name, catalog name)

B. Location(tried catalog Name, ip address, machine name)

The Log On to Server frame is disabled.

Test Connection succeeds, but trying to use a Table or a Query does not work out.

How do I configure the Connection?

TIA

Kar

I thought this would be simple enough, but I cant get it to work. Cant find much help on MSDN/BOL either.

Hope somebody here can help me!

TIA

Kar

|||

The following may be a good starting point:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefindservprovspec.asp

In general, when searching for OLE DB related information, you can usually also search in docs for technology that uses OLE DB, such as ADO. Things like connection string info and command syntax are usually just pass-through from those technologies to OLE DB, so their documentation will most likely apply.

|||

Thanks,

I managed to get it work, but the nomenclature(OLE DB versus SSIS Connection Manager Editor) is ambiguous.

The Provider part of the string is fine, but the other property names do not match.

I suppose Server or file Name=Data Source=catalog name, and

Location = Locale ID or probably it is the Server name if you are connecting to a remote server?

Best regards

Kar