Unfortunately, I have not collected the stats on how often my folks disconnect. As of now, it has not become a big problem for me, however if you have...

Looks like there was a typo in Step 2. Here's the new script.

/****** Object: StoredProcedure [dbo].[SelectAllServersFragmentedTables] Script Date: 09/12/2011 09:07:05 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--...

David, is there any trick to getting this set of reports and ssis working on S2k8? I have this rolled out on my environment which has 2000-2008 and I'm...

Great article Geoff, very useful thanks for sharing!

those messages above are all I have in ssi_errors.

yes i've tried both the server name and the named instance, neither works 🙁

Thanks for responding Wayne! Here are the errors I'm seeing:

component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

One or more component failed validation.

SSIS Error Code

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER....