Martin Elliott


Hi,

I am running SQL 2005 Enterprise with SP2. In the past I have been able to successfully create SSIS packages using the BIDS and also Maintenance Plans from within Management Studio.

Today I tried to edit a maintenance plan and got the following error message:-

TITLE: Microsoft SQL Server Management Studio
------------------------------

Retrieving the COM class factory for component with CLSID {0BE35203-8F91-11CE-9DE3-00AA004BB851} failed due to the following error: 80040154. (Microsoft.DataWarehouse)

------------------------------
BUTTONS:

OK
------------------------------


This error also occurs if I try to create a new Maintenance Plan.

I then tried opening an existing SSIS package in BIDS and got the following error:-

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

Microsoft Visual Studio is unable to load this document

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

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

These errors only occur on my PC so I know that the problem is with my PC. I have totally uninstalled SQL 2005 components from my PC and reinstalled them with no luck.

To my knowledge, I haven't installed any other programs since creating these packages, although there's a possiblilty my PC may have had some patches applied through SMS.

I am running Windows 2000 Professional.

Can anyone help me resolve this problem

Thanks.

Martin




Re: Unable to Edit or Create SSIS packages or Maintenance Plans

jwelch


Cumulative Update 2 for SP2 addresses some maintenance plan issues.

http://support.microsoft.com/kb/936305/LN/







Re: Unable to Edit or Create SSIS packages or Maintenance Plans

Martin Elliott

Thanks,

Have downloaded and installed the latest cumulative patch but unfortunately that made no difference.

I've reinstalled SQL 2005 client components, Visual Studio 2005 and the dot net framework 2.0 to no avail.

I have since experienced other problems with my PC so there's obviously something somewhere not quite right. Have decided the easiest way to solve this is to do a rebuild.





Re: Unable to Edit or Create SSIS packages or Maintenance Plans

DattaKhanolkar

Hello Martin,

Were you able to solve the problem

I have similar symptoms - I could create SSIS packages earlier, but now I am getting similar error while opening an existing package or creating a new one.