So far there have been two reoccurring problems caused by the instructions assuming there is a local instance.

An "OLE DB error" on step 7.1.3 when clicking preview

Cause: The Variable...

pepelf,

Part 3 will include all that and more.

MultiServer gets its server name from the expression ServerName @[User::SRV_Conn]

This variable is empty.

When I use the preview it connects to my local default instance.

Because it is empty it may...

Sounds like your connecting to the same server.

1) Check the MultiServer Connect and verify its propery setting expresssions is ServerName @[User::SRV_Conn]

2) Now check Populate ADO Variable properties.

The Result...

Try running the SQL through SQL management studio for the same instance QASRV.SQL_Overview is setup. This will confirm the syntax and verify that you have access.

The OLE DB Source should...

It can be used for both SQL Server 2000 and 2005 databases.

Most of the columns don't exist in SQL Server 7, so it would need to be customized for those...

I liked your SQL example. Inserts into tables with Identity columns can be challenging. So besides providing excellent advice on submitting forum questions you provide a flexible script for promoting...

Thank You - Thank You - Thank You

It was driving me nuts how to get the scripts copied and pasted.

Using Microsoft Word was the solution.

Fortunately, I did not need to...

I do enjoy the news letter. I try to read each morning I get to work.

You could remove most of the graphics because I don't even get them because my...

http://www.sqlmag.com/Articles/ArticleID/95385/95385.html

This SSIS package besides accessing multiple databases can access multiple servers

I found the problem.  It is a bug in the Management Studio.  When I use Management Studio updated with SP2 to create the Plan it works fine. Unfortunately we have some...

Thanks for all the feed back on the article.  I enjoyed reading about the additional free tools available and your comments on the article. I...

I was finally able to put together a simple script that generates a more complex password for the SA account.  It is 128 characters long and uses 81 different values.  You...

Our shop is currently virtualizing most servers to reduce hardware support costs.  So far we have not virtualized any SQL Server installations because of the performance hit they would take. ...

/*

The cntr_type value for SysPerfInfo changed with SQL Server 2005.

I modified the SQL in this thread to work with both SQL Server 2000 and 2005

/*

SELECT

...