Microsoft Visual Studio is unable to load this document after SQL Server SP2 install.

Hello all,

Over the weekend, I loaded the SQL Server SP2 on to my production database after having it on my dev server for two weeks with out any problems.

After I did this, I went to check all my SSIS packages and found them not able to load.

I get this message “Microsoft Visual Studio is unable to load this document: 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.

Now when I look at the errors I see:

Error 1 Error loading Master_Full_Weekly.dtsx: Error loading value "<DTS:LogProvider xmlns : DTS="www.microsoft.com/SqlServer/Dts" > <DTS : Property DTS:Name="ConfigString">SQL_TPMTSH_Datamart</DTS: Property><DTS : Property DTS:Name="DelayValidation">0</DTS: Property><DTS: Property DTS:Name="ObjectName">DTS Log Provider for SQL Serve" from node "DTS: LogProvider". D:\ETL\Projects\TPM\TPMTSH\Master_Full_Weekly.dtsx 1 1

Does anyone know what this is about and how I can go about fixing it?Anyone?|||

Could you try to register xml modules:

regsvr32 msxml3.dll

regsvr32 msxml6.dll

HTH.

Microsoft SQLXML Bulkload 4.0 Type Library with SQL Express

Hello,

I'm trying to follow a sample from microsoft for Using SQLXML Bulk Load in the .NET Environment

In the sample c# console app. it says to select add reference then In theCOM tab, selectMicrosoft SQLXML Bulkload 4.0 Type Library (xblkld4.dll) and clickOK.

The problem I have is I cannot find the library or the xblkd4.dll file on my pc.

Does anyone have any suggestions? Any help would be much appreicated.

Thanks

Karl

Hi,

From your description, it seems that you are unable to import the Microsoft SQLXML BulkLoad 4.0 type library, right?

Based on my understanding, XML Bulk Load is a standalone COM object that allows you to load semistructured XML data into Microsoft SQL Server tables. So before you are going to add the library, make sure that you have installed Microsoft SQL Server (i.e Microsoft SQLServer2005) product.

Thanks.

|||

I have the same problem. I have SQL Server 2005 with notification services installed locally and am using v2.0 of the frameworks and Team edition VS.Net 2005 SP1 and am working in C#. I have install SQLXML v4 and have located the dll next to the v3 dll which is listed as a COM object in the reference listing of COMs.

Any help on what steps to take to install so the library shows up in the COM listing would be appreciated.

Edwin

|||

I found a good article on this.

http://64.233.169.104/search?q=cache:jsAQOib9cFoJ:wijix.com/blogs/centricity/archive/2007/04/30/bulk-loading-xml-into-sql-server-2005-using-net.aspx+SQLXMLBulkLoad+Visual+studio+2005+reference&hl=en&ct=clnk&cd=2&gl=us

|||

The link was extremely helpful. Thanks.

Microsoft sql server smo

Im trying to use

Microsoft.SqlServer.Management.Smo

to load a dropdown of available sql server databases.

On my computer it works fine but when i try and run the application on my virtual it throws and unhandled exception that it couldn't load SMO assembly. I know this is because 2005 isn't installed on my virtual but i want to be able to catch this error and just ignore it and load a blank dropdown. I tried putting try catch blocks around the load but it still errors. I then tried instead of importing it i tried to reference smo by using the whole name inside of my try catch block.

Does anyone know how to catch this error

Try' Create a new connection to the selected server nameDim srvConnAs New Microsoft.SqlServer.Management.Common.ServerConnection(txtServerName.Text)Dim srvSqlAs Microsoft.SqlServer.Management.Smo.Server' Log in using SQL authentication instead of Windows authentication srvConn.LoginSecure =False' Give the login username srvConn.Login = txtUserID.Text' Give the login password srvConn.Password = txtPassword.Text' Create a new SQL Server object using the connection we created srvSql =New Microsoft.SqlServer.Management.Smo.Server(srvConn)' Loop through the databases listFor Each dbServerAs Microsoft.SqlServer.Management.Smo.DatabaseIn srvSql.Databases' Add database to combobox txtDatabase.Items.Add(dbServer.Name)Next Catch exAs Exception MsgBox(ex.Message)End Try

I know this is because 2005 isn't installed on my virtual but i want to be able to catch this error and just ignore it and load a blank dropdown

smo object should work on a sql 2000 server, I have done it before. What is th exact error message your getting?

|||

What i have read tells me that smo is new in 2005 and does not work in 2000. But any case i want to ignore this error and just populate the dropdowns as blank if no sql server is installed at all.

The exact error message is:

Could not load file or assembly Microsoft.SqlServer.SMO
Version 9.0.242.0, Culture=neutral
PublicKey Token=89845dcd8080cc91 or one of its dependencies. The system cannot find the file specified

Microsoft SQL Server Management Studio Express Load Error!

Hi,
I was using MSSMSE till yesterday absolutely with no problem from last 6
months.
But suddenly when I tried to open it this morning, it said Package
'Microsoft SQL Management Studio Package' failed to load.
Then I reinstalled , (repaired) this package twice. But no luck. Still it
gives same error upon opening. I can't manage my SQL database without it.
Does anyone know what is this and how to fix it?
Your help will be really appreciated.
Thanks & Tegards,
Sujata
Hi,
I am getting the exact same error with the Standard edition. Reinstallation
didn't help either.
Does anyone else have the same problem?
Thanks,
Jim
"Sujata P" wrote:

> Hi,
> I was using MSSMSE till yesterday absolutely with no problem from last 6
> months.
> But suddenly when I tried to open it this morning, it said Package
> 'Microsoft SQL Management Studio Package' failed to load.
> Then I reinstalled , (repaired) this package twice. But no luck. Still it
> gives same error upon opening. I can't manage my SQL database without it.
> Does anyone know what is this and how to fix it?
> Your help will be really appreciated.
> Thanks & Tegards,
> Sujata