SSIS error 0xC0011008 Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage












0















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.










share|improve this question























  • 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








  • 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
















0















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.










share|improve this question























  • 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








  • 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














0












0








0








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.










share|improve this question














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






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 20 '18 at 19:50









FedeFede

3111312




3111312













  • 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








  • 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











  • 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












1 Answer
1






active

oldest

votes


















0














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.






share|improve this answer























    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
    });


    }
    });














    draft saved

    draft discarded


















    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









    0














    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.






    share|improve this answer




























      0














      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.






      share|improve this answer


























        0












        0








        0







        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.






        share|improve this answer













        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.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 21 '18 at 15:19









        FedeFede

        3111312




        3111312
































            draft saved

            draft discarded




















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Guess what letter conforming each word

            Port of Spain

            Run scheduled task as local user group (not BUILTIN)