Tag Archives: ssis

Connect to SSIS Service on machine failed | Error loading type library/DLL

Today one of the members of the Project DBA Team installed SQL Server Integration Services (SSIS) 2005 on one of the production servers. The installation was successful and the first thing anyone would do to confirm is connect to SSIS … Continue reading

Posted in SQLServerPedia Syndication, Troubleshoot | Tagged , , | 3 Comments

Does Maintenance Plan depend on SSIS?

Yesterday, I responded to a post in which the Maintenance Plans were failing after the cluster resources failed over. The user doubted that on the passive node (now active after failover), the Service Pack installation was not done properly and … Continue reading

Posted in maintenance plan, SQLServerPedia Syndication, Troubleshoot | Tagged , | Leave a comment