Thanks Mike and Elliot.

Hmmm, can anyone give me a clue for how to do this via an SSIS package?

I'm familiar with Foreach loops but not sure how to be able...

Thanks, Michael.

No, I'm trying to avoid using Linked Servers.

With CMS you can query many servers via a single query. Info for all your central management servers is returned.

But I want...

Thanks Gsquared and SteveJones.

I didn't uninstall anything.

The BIDS and Mgmt Studio installed successfully, although I got several warnings of "Compatibility issues", thruout the install.

Seems to be OK.

John

Does anyone have any advice?

Brandie, I have discovered the root cause of the installation failures.

We recently moved from Symantec Antivirus to Kaspersky. I never had this problem when my servers and PCs were running...

Mr. Certifiable,

Thanks for your suggestions. I will work on the registry issue.

Appropriately humbled. John

I'm not using a DVD. Installing from folders on the laptop that I copied from the server that holds all install files. You remember, the "Servers" and "Tools" folders....

Thanks for your interest Brandi.

I have used this same install file dozens of times. On the chance it got copied during the copy from the server, I recopied it and...

In addition to the above stuff which is fom the Summary.txt ....

SQLSetup....Core.log shows:

Unattended=false

WorkDir=C:\Downloads\SQLSTDSEL\Servers

}} {t:\yukon\sql\setup\sqlcu\dll\scusetupmgr.cpp:501}

ScuProgressDlg::SetupFinished()

ScuProgressDlg::DialogProc() installation done... waiting for setup mgr

<EndFunc Name='UpdateComponents' Return='1603' GetLastError='0'>

Component update returned a fatal error : 1935

...

The Linked Server connection is working well without me making any changes.

We can close this post.

Thanks, John

Thanks for your reply.

The consultant asked to be able to connect from the 2000 server.

And because his software is installed on that server, that is also my preference.

At this...

I'm just running the sql code in the Query Analyzer window.

And I get the same error when I set the report path to the local server.

Obviously, I'm doing something...

Well sorry, Welsh.

When I run it in Mgmt Studio, no report is generated and I get this in the Results panel:

(The report path is on a different server)

usage: bcp {dbtable...

Impressive. Sounds like you have developed a tool that you could sell. But anyone can buy software. I want to build it myself. I've had this dream for a couple...

Well I like what I hear, Elliott. You have piqued my curiosity. Are you using CLR?

Please elaborate. All my servers are either 2005 or 2008 with several of those...