Post reply

Can't Load DTSX file into 2008 sql database

  • January 10, 2019 at 8:24 am

    #381174

    I have a package I have developed in VS2015, using an SQL 2008 server. Simple package that loops thru files in a folder and loads them

    I can execute the package from the VS2015 environment fine.

    I copy the file to the database server and I logon to SSMS Integration services and I want to import the file to the database. with this window


      When I do I get the following error
    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.

    Any thoughts?

  • January 10, 2019 at 2:22 pm

    #2018632

    I haven’t ever published packages to 2008 in this way. I deploy them with the manifest file and then set them up as an agent job in SSMS (database engine).

    When you set up the step in the job, you can point to “file system” and search for the installed package. 2012 onwards uses SSIS catalogues and makes life much easier.

    Hope this helps.

    Dave

  • January 10, 2019 at 4:13 pm

    #2018645

    Dave,
    Thanks for the solutions,  I'm still new to this, can you point me to how to create a manifest file and directions on deployment?
    Eric

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply