Can't create a Maint Plan in 2005

I am trying to create a maint plan in 2005 and no matter what types of
things I tell it to do, when it goes to create the plan I get the following
error message:
Create maint plan failed.
Additional information:
create failed for jobstep 'Subplan'
An exception occurred while executing a Transact-SQL statement or
batch.
The specified '@.subsystem' is invalid (valid values are returned
by sp_enum_sqlagent_subsystems) (Microsoft SQL Server Error:14234)
It's on a clustered system.
TIA - Jeff.Do you have SQL Agent running and do you have SSIS installed and running?
Andrew J. Kelly SQL MVP
"UJ" <fred@.nowhere.com> wrote in message
news:epT9r3uQGHA.5808@.TK2MSFTNGP12.phx.gbl...
>I am trying to create a maint plan in 2005 and no matter what types of
>things I tell it to do, when it goes to create the plan I get the following
>error message:
> Create maint plan failed.
> Additional information:
> create failed for jobstep 'Subplan'
> An exception occurred while executing a Transact-SQL statement or
> batch.
> The specified '@.subsystem' is invalid (valid values are
> returned by sp_enum_sqlagent_subsystems) (Microsoft SQL Server
> Error:14234)
> It's on a clustered system.
> TIA - Jeff.
>

Can't create a Maint Plan in 2005

I am trying to create a maint plan in 2005 and no matter what types of
things I tell it to do, when it goes to create the plan I get the following
error message:
Create maint plan failed.
Additional information:
create failed for jobstep 'Subplan'
An exception occurred while executing a Transact-SQL statement or
batch.
The specified '@.subsystem' is invalid (valid values are returned
by sp_enum_sqlagent_subsystems) (Microsoft SQL Server Error:14234)
It's on a clustered system.
TIA - Jeff.
Do you have SQL Agent running and do you have SSIS installed and running?
Andrew J. Kelly SQL MVP
"UJ" <fred@.nowhere.com> wrote in message
news:epT9r3uQGHA.5808@.TK2MSFTNGP12.phx.gbl...
>I am trying to create a maint plan in 2005 and no matter what types of
>things I tell it to do, when it goes to create the plan I get the following
>error message:
> Create maint plan failed.
> Additional information:
> create failed for jobstep 'Subplan'
> An exception occurred while executing a Transact-SQL statement or
> batch.
> The specified '@.subsystem' is invalid (valid values are
> returned by sp_enum_sqlagent_subsystems) (Microsoft SQL Server
> Error:14234)
> It's on a clustered system.
> TIA - Jeff.
>

Can't create a Maint Plan in 2005

I am trying to create a maint plan in 2005 and no matter what types of
things I tell it to do, when it goes to create the plan I get the following
error message:
Create maint plan failed.
Additional information:
create failed for jobstep 'Subplan'
An exception occurred while executing a Transact-SQL statement or
batch.
The specified '@.subsystem' is invalid (valid values are returned
by sp_enum_sqlagent_subsystems) (Microsoft SQL Server Error:14234)
It's on a clustered system.
TIA - Jeff.Do you have SQL Agent running and do you have SSIS installed and running?
--
Andrew J. Kelly SQL MVP
"UJ" <fred@.nowhere.com> wrote in message
news:epT9r3uQGHA.5808@.TK2MSFTNGP12.phx.gbl...
>I am trying to create a maint plan in 2005 and no matter what types of
>things I tell it to do, when it goes to create the plan I get the following
>error message:
> Create maint plan failed.
> Additional information:
> create failed for jobstep 'Subplan'
> An exception occurred while executing a Transact-SQL statement or
> batch.
> The specified '@.subsystem' is invalid (valid values are
> returned by sp_enum_sqlagent_subsystems) (Microsoft SQL Server
> Error:14234)
> It's on a clustered system.
> TIA - Jeff.
>

Cant convert types

I ham trying to convert a 'System.Data.CommandType' to 'System.Web.UI.WebControls.SqlDataSourceCommandType'.

but I get

Error 4 Cannot implicitly convert type 'System.Data.CommandType' to 'System.Web.UI.WebControls.SqlDataSourceCommandType'. An explicit conversion exists (are you missing a cast?) D:\Inetpub\wwwroot\Help_Desk\App_Code\HelpDeskSql.cs 99 42 http://localhost/Help_Desk/

My problem is I cant seem to get a explicit conversion to work. if it cast it I get an.

Specified argument was out of the range of valid values.
Parameter name: value . when running the page. but no build errors, does anyone know how to cast this?

Show us your exact code or markup that you're talking about, which is giving you the error.|||

if (cmdUpdate !=null)

{

HDS.UpdateCommand = cmdUpdate.CommandText;

HDS.UpdateCommandType = (SqlDataSourceCommandType)cmdUpdate.CommandType; //errror line

for (int i = 0; i < cmdUpdate.Parameters.Count; i++)

{

HDS.UpdateParameters.Add(cmdUpdate.Parameters[i].ParameterName, cmdUpdate.Parameters[i].Value.ToString());

}

}