.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

0xC0011008 when deploying a SQL2005 .dtsx package after modifying with XMLDocument

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

I am making an installer to deploy our SSIS packages for our customers so they could run an install sheild type project.  I need to change datasources in the package depending on our customer.  So, I made a .NET app that uses XML.XPath to parse the dtsx package and update the datasources with their server and databases.  The problem is when I do XML.XMLDocument.Save() it reformats the XML, to me is seems only a whitespace formatting.  This is fine for SQL 2008 packages but SQL 2005 dtutil.exe chokes with the following error on deployment:

Could not load package "ProcessCubes.dtsx" because of error 0xC0011008.
Description: The package failed to load due to error 0xC0011008 "Error loading f
rom XML. No further detailed error information can be specified for this problem
 because no Events object was passed where detailed error information can be sto
red.". This occurs when CPackage::LoadFromXML fails.


Thanx, Adam

View Complete Post

More Related Resource Links

SSIS "Save copy of Package.dtsx as" is not available

Hello,I had previously upgraded my Visual Studios to 2008 Pro, and have just upgraded to SQL Management Studio 2008.  I can create/edit/upgrade packages using 2008, but when I attempt to put them on the server there is no File > "Save copy of Package.dtsx as" option available.  The only options are Save, Save as, and Save All.  Any ideas?

Deploying SSIS Package configurations in production and development


I'm working on a SSIS package which I want to deploy onto our development environment on a daily basis as I work on it. In addition, I want it to be easy to deploy to production. We're using xml configuration files for our packages, but I haven't seen anyone discuss the entire development process.

Do people keep their production and development configuration files in source control? If so, how? Are they part of your BIDS SSIS project? I tried adding them to "Miscellaneous". i.e. Example:

I have a project with the following SSIS Packages in it:




In the Miscellaneous folder I have:






I did this so I can keep them in source control. We don't use package deployment utilities, we just deploy by hand, but putting the files in Miscellaneous breaks the building of the deployment utilities because it attempts to copy the config files into the Deployment directory twice.


In addition, I set up the package configurations such that the

dtutil won't deploy my package, "error 0xc0011008 loading from XML"


My package runs fine on the dev server with remote database.  SSMS deploys it to the msdb on the remote server, no problem, and it runs there with no problem.

But when I try to use dtutil from the command line to deploy it from a local .dtsx file to the remote server, I get the following message:

Microsoft (R) SQL Server SSIS Package Utilities

Version 9.00.1399.06 for 32-bit

Copyright (C) Microsoft Corp 1984-2004. All rights reserved.

Could not load package "foo.dtsx" because of error 0xC0011008.

Description: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.


Dev system is using Visual Studio 2008 and BI Studio R2, database server is SQl 2008 but not R2.

I don't think that matters.

What might matter is that I have embedded spaces in the file names and package names - just renaming the file didn't seem to help, I think I'll try renaming the package, for lack of any better idea to try.

Or, could it be a 32bit/64bit thing?  I'm not sure who is 32bit and who is 64bits, actually.





BIDS Error loading 'Package.dtsx' in 2008


So everything was working grand. I had both SQL2005 and 2008 installed and were working together just fine. Then I installed 2008R2. And everything was still fine minus the fact that I couldn't run anything with the dtexecui.

I have 2 computers that mirror each other in what's installed on them. SQL2005/2008/R2 were installed on both of them. Then when I started having package issues, I uninstalled R2.

Computer A works fine. After I uninstalled R2, I reinstalled the components from the sql2008 disk and packages work/open/run with dtexec/ui

On Computer B (which is the more important one of course) I get this error when trying to open a package (in bids).

Error    4    Error loading 'Package.dtsx' : Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..

And then it gives me the little red x in the right corner.

I tried re-registering everything based on this post http://social.msdn.microsoft.com/Forums/en-IE/sqlkjsetupandupgrade/thread/5ed7480b-2ca5-48de-bd3b-4b3752237c31 and that didn't work.

Then I uninstalled SQL2008, reinstalled, applied SP1, it still didn't work. Then I re-registered things again and it still d

Content Editor text format functionality lost after deploying branding solution package


I've got two identical SharePoint 2010 servers.  One is a dev box and one is production.  We've got a branding solution package.  After deploying the package on the production server, when I go into edit a page, the text format functionality in the content editor works fine, i.e. I can change font, font size, font color, etc.  However, when I deploy the solution package on the dev server and then attempt to edit a page, the text format functionality is disabled/broken.  I can utilize bold, underline, or italicize but cannot change font, font color, font size, etc. 

I've copied a site collection from my production site (which works perfectly) over to the dev site with the same results, meaning once on the dev box, the copied site collection no longer has editing functionalilty in the content editor. Permissions are set the same on both boxes and as mentioned, editing works fine until deployment of the solution package on the dev box.   Any help would be greatly appreciated. 

Could Visual Studio installed on my Dev box cause this?


job fails when running a dtsx package


hi all,

I am trying to solve the following problem: I have an SSIS package developed with VS2008 that simply dumps a text file into a table.
The file is on a network.

1. From the VS 2008, running the project doesn't give any errors - it fills the table OK.
2. I added the dtsx package to the Data Collector folder under Stored Packages/MSDB - I executed the package from there, again NO ERROR.
3. I created a job and added one step that is the dtsx package - it fails saying The file name "\\myFileServer\myData\myFolder\H29102010.txt" specified in the connection was not valid.  End Error  Error: 2010-10-29 10:03:11.83     Code: 0xC001401D     Source: myJOB      Description: Connection "c1" failed validation.  End Error  Error: 2010-10-29 10:03:11.84     Code: 0xC001401E     Source: myJOB Connection manager "c1"

The SSIS service is not running under NT ADMIN\Network Service but I changed to an account that can read/write to the above network location.
Also the package has been saved with password encryption (the user key encryption would raise erorrs, too).

What I can't understand is why would the packa

Error while deploying a WSP with Unrestricted="true" in the Package.Template.xml


Does anyone know how to create a CAS PermissionSet that allows for Unrestricted="true" in the Package.Template.xml file for a Visual Studio 2010 SharePoint Project?  The following does not work.

<?xml version="1.0" encoding="utf-8"?>
<Solution xmlns="http://schemas.microsoft.com/sharepoint/">

Error opening an DTSx package


Hi everyone,

I get this error when I try to open a DTSx package in my machine, can anyone help me ? I've all the dlls that I need ( at least the ones that I think I need ) registred on assembly and in the right places. 

Uploaded with ImageShack.us





Thanks a lot for your help

deploying to msdeploy does not support a proxy server


I am trying to deploy through webmatrix but my system Proxy server configuration is not being used. I assume that webmatrix would detect the proxy server settings and use that for the msdeploy calls under the hood. Can anyone confirm this is a know issue? 

Problems posting to a package


Hey Y'all

I'm currently creating a program that accesses a mysql package to add data to a few tables.  I'm currently getting an error that says  "

ORA-01403: no data found
ORA-06512: at "JESSE.PKG_WORKPLAN", line 42
ORA-06512: at "JESSE.PKG_WORKPLAN", line 177
ORA-06512: at line 1


These lines are


and 177:add_team_members(V_PROJECT_ID, V_START_DATE, v_FISC_YEAR, V_MEMBERS ,V_NUM_MEMBERS,'add');

Checking these variables in my asp.net page they are all receiving parameters.

Is there a  way to see what the database is actually receiving from the asp.net page?

Or is there another thing to be looking at?


Modifying connection String in Web config using Install Wizard



Im trying to create a Web Deployment Project, the built in setup and deployment is very good in Visual Studio, i need to able to add an additional step in the setup to change the connection string in the Web config file. Ive seen a lot of articles on how to do this and in particular this http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx#7162670 I am however stuck on the final part of this tutorial, im using the code Scott provided but have two errors,  heres part of my code where the errors are

using System;
using System.Configuration;
using System.Configuration.Install;
using System.ComponentModel;
using System.Diagnostics;
using System.IO;
using System.DirectoryServices;

 void ConfigureDatabase(string targetSite, string targetVDir, string connectionString)
            // Retrieve "Friendly Site Name" from IIS for TargetSite
            DirectoryEntry entry = new DirectoryEntry("IIS://LocalHost/" + targetSit

SMTP not working if I use web deployment package to deploy my app.


Hi all

I use msdeploy to install my web app. deployment package. everything about web app works, but find out email was not working.

I checked telnet smtp is running.

I debug the project, and it was sending out email too.

So my solution was upload the whole project (not complied) to wwwroot, and email works too. Thats why I assume the deployment cause the problem.

at last, I also tried to copy the web deployment web.config to replace the project's web.config, and the email also work, so it wasn't the web.config problem.

Could anyone tell me whats going on?

My environment:

window 2003

iis 6

.net framework 4.0

Windows Azure: Developing and Deploying Cloud Apps in Visual Studio 2010


You'll find direct support for building Windows Azure applications in Visual Studio 2010 and Visual Web Developer 2010 Express. We'll walk you through using Visual Studio 2010 for the entirety of the Windows Azure application development lifecycle.

Jim Nakashima

MSDN Magazine April 2010

Cloud Patterns: Designing and Deploying Services for Windows Azure


To better understand how SOA patterns can be applied to Windows Azure deployments, we walk you through a scenario in which a bank moves its services to the cloud.

Thomas Erl, Arman Kurtagic, Herbjörn Wilhelmsen

MSDN Magazine January 2010

SharePoint's Sandbox: Developing, Deploying and Monitoring Sandboxed Solutions in SharePoint 2010


The challenge in SharePoint development has always been the balance between creating and deploying solutions that you can trust not to damage or impair a SharePoint farm. A new feature in SharePoint 2010, called Sandboxed Solutions, enables farm administrators to feel comfortable that the SharePoint farm is safe, gives site collection administrators the authority to manage applications in their site collection, and provides developers with the flexibility to create solutions they know will be deployed in a safe and rapid manner.

Paul Stubbs

MSDN Magazine November 2009

Interop: Get Seamless .NET Exception Logging From COM Clients Without Modifying Your Code


Using .NET objects from ASP can help you gain experience with the .NET Framework before migrating to ASP.NET. Your ASP pages will make use of the new .NET components through COM-callable wrappers (CCW). But how will you handle exceptions? This article fills you in.

Matt Adamson

MSDN Magazine January 2005

Code Name Longhorn: A First Look at Writing and Deploying Apps in the Next Generation of Windows


The next version of the Microsoft Windows operating system, code-named "Longhorn," marks a significant change not only in terms of how the operating system works, but also in the way in which applications are built. The Longhorn version of Windows includes a new storage system, natural search technology, and an increased emphasis on security and trustworthy computing. Here the author provides an overview of Longhorn, focusing on the build-once, deploy n-times application model. In addition, he discusses the new language, code-named "XAML," that's used to create UI elements, then presents some working samples.

Dino Esposito

MSDN Magazine January 2004

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend