Mixing
SSIS error 0xC0011008 Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage
Im calling Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage from a .net(V4.0) application to load ssis package that are installed into the local disk of a VM Windows Server 2016. I run this code from Visual Studio 2017 Community in debug mode to test my integrations.
The packages ssis were created in Visual Studio 2010 and I migrated them to be compatible with Visual Studio 2017. They integrate data into a SQL server 2017. If I simply execute my packages from my SSIS solution it works perfectly, but when I load them within my other C# code using Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage, I get the following error:
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.
By the way, is not a code problem as it works perfectly in my actual environement(Windows Server 2012 R2 targeting SQL Server 2017) with the exactly same code. I think is more version compatibility related or server configuration.
.net
sql-server ssis dts asked Nov 20 '18 at 19:50
FedeFede
3061312
add a comment |
Im calling Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage from a .net(V4.0) application to load ssis package that are installed into the local disk of a VM Windows Server 2016. I run this code from Visual Studio 2017 Community in debug mode to test my integrations.
The packages ssis were created in Visual Studio 2010 and I migrated them to be compatible with Visual Studio 2017. They integrate data into a SQL server 2017. If I simply execute my packages from my SSIS solution it works perfectly, but when I load them within my other C# code using Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage, I get the following error:
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.
By the way, is not a code problem as it works perfectly in my actual environement(Windows Server 2012 R2 targeting SQL Server 2017) with the exactly same code. I think is more version compatibility related or server configuration.
.net
sql-server ssis dts asked Nov 20 '18 at 19:50
FedeFede
3061312
Have you checked that the correct version of theMicrosoft.SqlServer.ManagedDTS.dllis installed on the VM? We had a similar problem when testing through environments
– Matt
Nov 20 '18 at 19:59
Hello Matt, how do i know what is the correct version and how do I check that it is correctly installed? Actually I kept the same version in the project has it was added with Nuget, but I don't know which version I must upgrade to
– Fede
Nov 20 '18 at 20:07
2
So Integration Services is a server component and isn't redistributeable, so you've added the reference with Nuget but you need to run the install for the Client Tools SDK on the VM
– Matt
Nov 20 '18 at 20:16
I have installed SSDT on my VM through this url docs.microsoft.com/en-us/sql/ssdt/…. Is Client Tools Sdk something different? Where can I get it? My VM where I run the process doesn't have any SQL server instance installed.
– Fede
Nov 21 '18 at 8:27
Yes, the SDK is a feature within the SQL Server installer. You will need to run that on your VM. I'm trying to find a picture for you...
– Matt
Nov 21 '18 at 12:46
add a comment |
Im calling Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage from a .net(V4.0) application to load ssis package that are installed into the local disk of a VM Windows Server 2016. I run this code from Visual Studio 2017 Community in debug mode to test my integrations.
The packages ssis were created in Visual Studio 2010 and I migrated them to be compatible with Visual Studio 2017. They integrate data into a SQL server 2017. If I simply execute my packages from my SSIS solution it works perfectly, but when I load them within my other C# code using Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage, I get the following error:
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.
By the way, is not a code problem as it works perfectly in my actual environement(Windows Server 2012 R2 targeting SQL Server 2017) with the exactly same code. I think is more version compatibility related or server configuration.
.net
sql-server ssis dts asked Nov 20 '18 at 19:50
FedeFede
3061312
Im calling Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage from a .net(V4.0) application to load ssis package that are installed into the local disk of a VM Windows Server 2016. I run this code from Visual Studio 2017 Community in debug mode to test my integrations.
The packages ssis were created in Visual Studio 2010 and I migrated them to be compatible with Visual Studio 2017. They integrate data into a SQL server 2017. If I simply execute my packages from my SSIS solution it works perfectly, but when I load them within my other C# code using Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage, I get the following error:
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.
By the way, is not a code problem as it works perfectly in my actual environement(Windows Server 2012 R2 targeting SQL Server 2017) with the exactly same code. I think is more version compatibility related or server configuration.
.net
sql-server ssis dts .net
sql-server ssis dts asked Nov 20 '18 at 19:50
FedeFede
3061312
asked Nov 20 '18 at 19:50
FedeFede
3061312
asked Nov 20 '18 at 19:50
FedeFede
3061312
asked Nov 20 '18 at 19:50
FedeFede
3061312
asked Nov 20 '18 at 19:50
FedeFede
3061312
3061312
Have you checked that the correct version of theMicrosoft.SqlServer.ManagedDTS.dllis installed on the VM? We had a similar problem when testing through environments
– Matt
Nov 20 '18 at 19:59
Hello Matt, how do i know what is the correct version and how do I check that it is correctly installed? Actually I kept the same version in the project has it was added with Nuget, but I don't know which version I must upgrade to
– Fede
Nov 20 '18 at 20:07
2
So Integration Services is a server component and isn't redistributeable, so you've added the reference with Nuget but you need to run the install for the Client Tools SDK on the VM
– Matt
Nov 20 '18 at 20:16
I have installed SSDT on my VM through this url docs.microsoft.com/en-us/sql/ssdt/…. Is Client Tools Sdk something different? Where can I get it? My VM where I run the process doesn't have any SQL server instance installed.
– Fede
Nov 21 '18 at 8:27
Yes, the SDK is a feature within the SQL Server installer. You will need to run that on your VM. I'm trying to find a picture for you...
– Matt
Nov 21 '18 at 12:46
add a comment |
Have you checked that the correct version of theMicrosoft.SqlServer.ManagedDTS.dllis installed on the VM? We had a similar problem when testing through environments
– Matt
Nov 20 '18 at 19:59
Hello Matt, how do i know what is the correct version and how do I check that it is correctly installed? Actually I kept the same version in the project has it was added with Nuget, but I don't know which version I must upgrade to
– Fede
Nov 20 '18 at 20:07
2
So Integration Services is a server component and isn't redistributeable, so you've added the reference with Nuget but you need to run the install for the Client Tools SDK on the VM
– Matt
Nov 20 '18 at 20:16
I have installed SSDT on my VM through this url docs.microsoft.com/en-us/sql/ssdt/…. Is Client Tools Sdk something different? Where can I get it? My VM where I run the process doesn't have any SQL server instance installed.
– Fede
Nov 21 '18 at 8:27
Yes, the SDK is a feature within the SQL Server installer. You will need to run that on your VM. I'm trying to find a picture for you...
– Matt
Nov 21 '18 at 12:46
Have you checked that the correct version of the
Microsoft.SqlServer.ManagedDTS.dll is installed on the VM? We had a similar problem when testing through environments– Matt
Nov 20 '18 at 19:59
Have you checked that the correct version of the
Microsoft.SqlServer.ManagedDTS.dll is installed on the VM? We had a similar problem when testing through environments– Matt
Nov 20 '18 at 19:59
Hello Matt, how do i know what is the correct version and how do I check that it is correctly installed? Actually I kept the same version in the project has it was added with Nuget, but I don't know which version I must upgrade to
– Fede
Nov 20 '18 at 20:07
Hello Matt, how do i know what is the correct version and how do I check that it is correctly installed? Actually I kept the same version in the project has it was added with Nuget, but I don't know which version I must upgrade to
– Fede
Nov 20 '18 at 20:07
2
2
So Integration Services is a server component and isn't redistributeable, so you've added the reference with Nuget but you need to run the install for the Client Tools SDK on the VM
– Matt
Nov 20 '18 at 20:16
So Integration Services is a server component and isn't redistributeable, so you've added the reference with Nuget but you need to run the install for the Client Tools SDK on the VM
– Matt
Nov 20 '18 at 20:16
I have installed SSDT on my VM through this url docs.microsoft.com/en-us/sql/ssdt/…. Is Client Tools Sdk something different? Where can I get it? My VM where I run the process doesn't have any SQL server instance installed.
– Fede
Nov 21 '18 at 8:27
I have installed SSDT on my VM through this url docs.microsoft.com/en-us/sql/ssdt/…. Is Client Tools Sdk something different? Where can I get it? My VM where I run the process doesn't have any SQL server instance installed.
– Fede
Nov 21 '18 at 8:27
Yes, the SDK is a feature within the SQL Server installer. You will need to run that on your VM. I'm trying to find a picture for you...
– Matt
Nov 21 '18 at 12:46
Yes, the SDK is a feature within the SQL Server installer. You will need to run that on your VM. I'm trying to find a picture for you...
– Matt
Nov 21 '18 at 12:46
add a comment |
1 Answer
1
active
oldest
votes
I resolved the problem upgrading my project to version 4.6 of the .net framework.
Also as Matt said, you have to install the SDK tools also.
Thanks for the help.
answered Nov 21 '18 at 15:19
FedeFede
3061312
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400534%2fssis-error-0xc0011008-microsoft-sqlserver-dts-runtime-application-loadpackage%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I resolved the problem upgrading my project to version 4.6 of the .net framework.
Also as Matt said, you have to install the SDK tools also.
Thanks for the help.
answered Nov 21 '18 at 15:19
FedeFede
3061312
add a comment |
I resolved the problem upgrading my project to version 4.6 of the .net framework.
Also as Matt said, you have to install the SDK tools also.
Thanks for the help.
answered Nov 21 '18 at 15:19
FedeFede
3061312
add a comment |
I resolved the problem upgrading my project to version 4.6 of the .net framework.
Also as Matt said, you have to install the SDK tools also.
Thanks for the help.
answered Nov 21 '18 at 15:19
FedeFede
3061312
I resolved the problem upgrading my project to version 4.6 of the .net framework.
Also as Matt said, you have to install the SDK tools also.
Thanks for the help.
answered Nov 21 '18 at 15:19
FedeFede
3061312
answered Nov 21 '18 at 15:19
FedeFede
3061312
answered Nov 21 '18 at 15:19
FedeFede
3061312
answered Nov 21 '18 at 15:19
FedeFede
3061312
3061312
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53400534%2fssis-error-0xc0011008-microsoft-sqlserver-dts-runtime-application-loadpackage%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you checked that the correct version of the
Microsoft.SqlServer.ManagedDTS.dllis installed on the VM? We had a similar problem when testing through environments– Matt
Nov 20 '18 at 19:59
Hello Matt, how do i know what is the correct version and how do I check that it is correctly installed? Actually I kept the same version in the project has it was added with Nuget, but I don't know which version I must upgrade to
– Fede
Nov 20 '18 at 20:07
2
So Integration Services is a server component and isn't redistributeable, so you've added the reference with Nuget but you need to run the install for the Client Tools SDK on the VM
– Matt
Nov 20 '18 at 20:16
I have installed SSDT on my VM through this url docs.microsoft.com/en-us/sql/ssdt/…. Is Client Tools Sdk something different? Where can I get it? My VM where I run the process doesn't have any SQL server instance installed.
– Fede
Nov 21 '18 at 8:27
Yes, the SDK is a feature within the SQL Server installer. You will need to run that on your VM. I'm trying to find a picture for you...
– Matt
Nov 21 '18 at 12:46