July 28, 2008 at 8:55 am
I am using SQL Server 2005 SP2 on Windows Server 2003. Whenever I try and Create and then schedule a Maintenance Plan I get the follwoign error pop up.
"Method not found: 'Boolean Microsoft.SqlServer.Management.SqlMgmt.JobScheduleData.UpdateSourceSchedule()'."
If I try and create a Maintenance Plan via the Wizard I get. The Following Error Message.
Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.Management.MaintenancePlanWizard)
I have tried uninstalling and reinstalling both SQL Server and .Net but still get the same errors.
July 28, 2008 at 9:02 am
SSIS is required for maintenance plans. Is it installed and running?
July 28, 2008 at 9:39 am
I have SSIS installed and the service is running nut when I attempt to create a New Project using the SQL Server BI Designer as soon as I add a Data Flow Task to the project I get the following error.
Object reference not set to an instance of an object. (Microsoft.DataTransformationServices.Design)
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.GetDiagramOwner(DtsContainer executable)
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.ActivateDiagramWithExecutable(DtsContainer executable)
at Microsoft.DataTransformationServices.Design.DtrPackageDesigner.DoDefaultActionForTask(TaskHost task)
I removed and Reinstalled the SQL Server BI Components but still the same errors.
July 28, 2008 at 9:46 am
You have the server at SP2. Did you apply SP2 to your workstation to upgrade your client tools? Google doesn't provide any further feedback, unfortunately.
July 28, 2008 at 9:49 am
SP2 had changes to maintenance plans, and I believe removed the need for SSIS to be installed on the server. However both the client and the server need to be above SP2.
July 30, 2008 at 8:57 am
That was it Steve. It was as simple as me not having upgraded the Client Tools to SP2. As soon as I upgraded the Client Tools to SP2 everything began working like a charm. Thanks for your help.
July 31, 2008 at 8:44 am
NOTE: SP2 original release has SIGNIFICANT issues with maintenance plans. Please make sure you apply the GDR2 fix to get to a workable system. Actually you may wish to investigate updating to one of the now 8 Cumulative Updates.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 31, 2008 at 3:37 pm
Download SQL Server 2005 SP2 Version 9.00.3042. You don't need to reinstall everything. Just install the Client Components and Notification Services, and you will be fine.
Download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en
-Marlon Ribunal
SQL Server Database Administrator
July 31, 2008 at 3:51 pm
MarlonRibunal (7/31/2008)
Download SQL Server 2005 SP2 Version 9.00.3042. You don't need to reinstall everything. Just install the Client Components and Notification Services, and you will be fine.Download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en
-Marlon Ribunal
Actually, version 9.0.3042 is the original SP2 version that has a few issues that you really don't want to encounter. There is a post-fix available (as mentioned above) that will take you to version 9.0.3054 which is the minimum SP2 version you want to be at.
As mentioned above, I would recommend upgrading to at least CU6 if possible. If you can't upgrade the server - you can still upgrade the clients to that version with no problems.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 5:59 pm
Actually, version 9.0.3042 is the original SP2 version that has a few issues that you really don't want to encounter. There is a post-fix available (as mentioned above) that will take you to version 9.0.3054 which is the minimum SP2 version you want to be at.
As mentioned above, I would recommend upgrading to at least CU6 if possible. If you can't upgrade the server - you can still upgrade the clients to that version with no problems.
hmmmm...could this be the reason why I am having trouble with my notification task? 😛
SQL Server Database Administrator
February 22, 2010 at 8:31 pm
Hi,
We have 2005 with SP2 installed on windows 2003 server and everything was working fine till we installed WSS 3.0 on that machine. I have stopped the default site and the WSS has been installed on port 80. I am getting the below error when i try to run or open the existing package,
The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
After i create a new package, when i try to add a new dataflow task i am getting the same error which is explained in the threat.
The existing SSIS package is using cube refreshing, so i thought i have to have the default website up and running and started the default and stopped the WSS and it's application pool. But no luck.
Thanks in advance for your help.
Thanks,
Jegu
June 17, 2011 at 8:35 am
To avoid any DTS or Management Plans or SSIS problems you have to install SP 4 which is the latest and has ability to choose what you would like to update it fixed my problems with not be able to create an Management Plan. Here is a link
June 17, 2011 at 8:43 am
To avoid any DTS or Management Plans or SSIS problems you have to install SP 4 which is the latest and has ability to choose what you would like to update it fixed my problems with not be able to create an Management Plan. Here is a link
http://www.microsoft.com/download/en/details.aspx?id=7218
Good Luck,
Michael Zeydelis
June 17, 2011 at 9:45 am
Three plus year old post - SP4 was not available at the time of original post.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply