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 http://support.microsoft.com/kb/961126/). I dodn’t test this combo (2008 sp1 without SSIS), but I have no reason to doubt that KB article.

10 Replies to “Do maintenance plans require SSIS?”

  1. Alright, champs! Checked out mu88ai. Decent selection of games and the site’s fairly straightforward. Could be worth a look if you’re bored. Check it out here: mu88ai

  2. Hey, I’ve been messing around with 5588bet1 recently, and it’s alright! There’s a bunch of games on here, and the site’s easy to use. Check ’em out at 5588bet1.

  3. 1gomsv388 is where it’s at for online sabong wagering! They have a great selection of matches, and the odds are competitive. Highly recommended for a great sabong betting experience! Good luck! 1gomsv388

  4. Yo, C77com fam! Just checked out the site, and it’s looking fresh. Easy to navigate, and the games are legit. Definitely worth a spin! Check it out here c77com.

Leave a Reply

Your email address will not be published. Required fields are marked *