June 17, 2010 at 12:13 pm
everytime I try to create any maintenance plan it throws an exception
"
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
Retrieving the COM class factory for component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} failed due to the following error: 800700c1. (Microsoft.SqlServer.ManagedDTS)
"
So far I tried to register DTS.dll (regsvr32 dts.dll) no succcess.
OS: server 2008
SQL: 2008(RTM) 64 bit Std Ed with SP2.
February 19, 2014 at 10:02 am
http://support.microsoft.com/kb/2315727
It was fixed in service pack one.
Microsoft SQL Server 2008 R2 Service Pack 1 (SP1):
http://support.microsoft.com/kb/2528583
Or at minimum:
Cumulative Update 3 also known as build 10.50.1734.0:
February 19, 2014 at 10:47 am
While I recommend getting SP1 installed, I have been successful in working around this error by creating the maintenance plans from another machine that has SSMS installed. Just use SSMS on the other machine to connect to the instance and then create a MP - usually will work.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply