I used a couple of examples to build a dynamic connector.

1.Looping through SQL Servers using SSIS or Dynamically build connection to multiple SQL Servers

http://www.sanssql.com/2011/08/looping-through-sql-servers-using-ssis.html

2. Andy Leonards blog...

This worked fine for me under SQL Server 2005 SE sp2 on Windows 2003 r2 as well as under SQL Server 2008 R2 on Windows 2008 r2 for SQL jobs....

I found same on SQL running on Windows 2008 R2 cluster. I opened Performance Monitor application. Expanded Data Collection Set, then both the system diagnostics and system performance. Found the...

Great article Andy!

I found a unique way to reduce the number of rows I had to check, when I've got a SQL Server database as my source. I just add...

You hit the nail on the head. Many of the HP utilities are only 32 bit and will cause a x64 bit SQL Server to page wildly. An update of...

Although prefixing table names to indicate the type of table has been a good practice, we have other options in 2005. Why not utilize schemas?

I proposed the use of...

We have a 64bit 2003 sp1 and SS2K5 Enterprise w/ sp2 running. We too saw pages/sec exceeding Microsoft's recommend 20 pages/sec average.

We've identified two problems that are contributing to...

You have files and filegroups. Each SQL Server database is assigned at least one file in a primary filegroup, with .mdf extension. You may have up to 256 filegroups. Multiple...