THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Do maintenance plans require SSIS?

To many, this is a non-issue, since SSIS is installed anyhow. But not everyody installs SSIS. I for instance prefer to keep my production systems as clean as possible and only have what I really need (a principle which is harder and harder to live after as years go by...). Also, not all Editions of SQL Server comes with SSIS.

I did a test some months ago for SQL Server 2005 with a recent sp and also on SQL Server 2008. SQL Server 2008 did require SSIS (I tested both without and with SSIS installed), where 2005 sp2 didn't. I recently learned from Phil Brammer in MVP group that there has been progress. Here's the run-down, you don't need SSIS installed to execute maint plans:

SQL Server 2005 requires sp2.

SQL Server 2008 requires CU3 or sp1 (see I dodn't test this combo (2008 sp1 without SSIS), but I have no reason to doubt that KB article.

Published Wednesday, August 26, 2009 1:06 PM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



jerryhung said:

Good thing is that most of the time, one can install SSIS afterwards, and WITHOUT restarting required

I just installed one last week, needed to execute a SSIS package as SQL job

August 26, 2009 4:16 PM

Abhi said:

Great. That worked. I had a 2008 RTM and came across this error. Once I applied latest service pack, it started working like charm.

July 12, 2017 11:50 AM

Leave a Comment


This Blog


Privacy Statement