Cannot edit packages

I have sql server 2k5 sp2 cluster, IS is installed on both nodes. There are a few maintainence plans that work well until today, when I try to edit it, I got the following error message:

TITLE: Microsoft SQL Server Management Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

Value of '6/22/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.

Parameter name: Value (System.Windows.Forms)

BUTTONS:

OK

I have to drop the task and readd it.

what's wrong with this, is this something to do with failover cluster?

thanks

Hello,

I'm going to move this question over to the SQL Server Tools forum where I think folks will have an answer.

Thanks, -Matt

|||

I'm having the same problem with a package created with the maintenance wizard on SQL 2005. Did you ever get any answers to this problem?

Looking at the dbo.sys_jobsview I can't see anything out of line (of course the date in question shouldn't be out of bounds for the datepicker control on the form anyway).

The message that I get is:

TITLE: Microsoft SQL Server Management Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

Value of '7/12/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value (System.Windows.Forms)

BUTTONS:

OK

Which indicates a .Net System.Windows.Forms error. We are running MSSQL2005 SP2.

|||

The full stack dump is:

===================================

Cannot show the editor for this task. (Microsoft SQL Server Management Studio)

===================================

Value of '7/12/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value (System.Windows.Forms)

Program Location:

at System.Windows.Forms.DateTimePicker.set_Value(DateTime value)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskBackupControl.set_ExpireDate(DateTime value)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskBackupForm.SetTask(DbMaintenanceBackupTask task)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskBackupForm..ctor(TaskHost taskHost, IServiceProvider provider)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskBackupUI.GetView()
at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.GetTaskEditor()

|||

I just started to see same error when I tried to open one part of the maintenance job in SQL 2005.

Anyone?

|||

I'm getting the same error on one of my maintenance tasks too. Just on one task on one server, the other similar tasks seems to be fine.

Scott<-

|||See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1483359&SiteID=1

for an excellent writeup on this issue.

jkh

sql