SQL Server 2005 Maintenance Plan

[sendba]

Hi All

I tried to create a maintenace Plan for my Prod database.
I get the following error. I am doing it through wizard.
Please help.



- Creating maintenance plan "Dbname" (Error)
Messages
Create maintenance plan failed.

------------------------------
ADDITIONAL INFORMATION:

Create failed for JobStep 'Subplan'. (Microsoft.SqlServer.MaintenancePlanTasks)

For help, click:

http://go.microsoft.com/fwlink?Prod...ceptionText&EvtID=Create+JobStep&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)

For help, click:

http://go.microsoft.com/fwlink?Prod...9&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476

 

[mrdenny]

You need to install Integration Services on the server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sendba]

MRDENNY

where to get this integration services

Should i remove this instance and reinstall or else i can update the existing instance.

Thanks

 

[Catadmin]

Integration Services is a separate component, so you should be able to keep your instance installed and simply go to Add/Remove Programs, highlight the SQL 2k5 listing and click "Add Components" at the top of the box.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"