SSIS package change and Project element is missing error

  • Hi All,

    I am now venturing into the fun world of SSIS, only ever performed things in a tutorial sense but now am working in a Dev environment.

    So we have a long standing package which I have updated with an additional field to pull from an Oracle DB to our warehouse. I have also updated a field length.

    For some reason I am getting the error Exception deserializing the package "Project" element for Project is missing in the project manifest when trying to test and run it.

    This is part of a bigger package where several packages run as part of a daily run. I have resaved it, re-opened it (and the whole project). I haven't tried rebuilding the whole project as yet, is this the key? I see there is an option to add existing package should I do this so it picks it up? Seems really odd as I have updated items before and it has continued to work just not this time.

    The timed run goes at 10 so will see what it does at that point (if this fails) but was just after some pointers. I have done some research but none of the items seem to point to this.

    Thanks for any useful tips, if I find out in the meantime I will update here incase others ever have this.

  • For anyone who gets this, I half created an SSIS package and renamed it. This is what caused the issue, once I renamed the package back again everything worked ok.

  • Just ReBuild the entire solution. It works fine

  • Hello all, I got this error

    TITLE: Microsoft Visual Studio ------------------------------ Exception deserializing the package "'Project' element for Project is missing in the project manifest.". ------------------------------ ADDITIONAL INFORMATION: 'Project' element for Project is missing in the project manifest. (Microsoft.SqlServer.ManagedDTS) ------------------------------ BUTTONS: OK ------------------------------

     

    I renamed the package at the right pane (Solution explorer) and 'Save All'. Executed my package and my containers ran just fine.

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

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