Share via

There were errors while the package was being loaded. The package might be corrupted.

  • Article

Question

Wednesday, November 11, 2015 9:21 PM

I am in a new job and am trying to open a project from my previous job and am getting this error message.

It is erroring out on the connection managers which make sense. I just want to open it and reference what I've done in the past is all.

Also getting this warning message...

you are not using the same machine that was used to save the project.

Is there any way that I can open up this previous project? I hate like hell to have to go back to the drawing board and do something I know I've done before.

Thanks for your review and am hopeful for a reply.

All replies (6)

Tuesday, November 17, 2015 5:25 PM âś…Answered | 1 vote

When attempting to Open previous SSIS Solutions in Microsoft Visual Studio, you will get errors; most notably on the Connection Managers. In order to open previously developed SSIS Solutions in Microsoft Visual Studio, follow the following procedure.

  1. Copy the Error upon attempting to open the SSIS Project and the specific package into Microsoft Word
  2. Close the Project in Microsoft Visual Studio
  3. Open the specific .dtsx Package with Notepad++
  4. Locate the errors copied into Microsoft Word and delete those portions of the XML in Notepad++
  5. Save the .dtsx Package from Notepad++
  6. Re-Open the SSIS Solution in Microsoft Visual Studio and open the specific Package. There will still be errors, but the SSIS Package should now be visible for reference purposes

Thursday, November 12, 2015 6:10 AM

Hi ITBobbyP,

Which version of Visual Studio used to create your previous project and which version of current Visual Studio are you using?

If there are different Visual Studio version, please tell us the version of that two Visual Studio.

If they are the same version of Visual Studio, please check following points.

  1. Please check all packages installed on current Visual Studio, whether there has any packages which used in previous project are not installed on current Visual Studio.
  2. If all packages have been install on current Visual Studio, please check whether there has the same version between the previous project and current Visual Studio.
  3. Please create a new project with current Visual Studio and then move the project files from the previous project to the new project, which can help us make sure which project or which file causes the package load failed.
  4. If you have confirm which packages are corrupted, please uninstall and reinstall them.

Best Regards,
Weiwei

Thursday, November 12, 2015 1:26 PM

Thank You for your reply Weiwei.

I can most certainly tell you that our current version of Microsoft Visual Studio at my new job is...

Microsoft Visual Studio Professional 2012 - Version 11.0.50727.1

Microsoft .NET Framework - Version 4.5.50938

I do not remember the Microsoft Visual Studio version of my previously created project from my previous job. How can I tell?

Saturday, November 14, 2015 10:41 AM

Hi ITBobbyP,

Since different VS versions have his own compatibility, so it means that we couldn't update all projects to new/high VS versions, that's the reason why WeiWei wants to know the previous VS version you use. Since differnet VS versions have different icon or color, maybe you could remember it using these different features of different VS IDEs.

But if you really don't know what the previous VS version is, my suggestion is that you'd better to open this project in different VS versions. Note: please take a backup for the current project before you open it in different VS versions.

Of course, if you just could use the VS2012, please install the VS2012 update 4, please also take a backup for this project, and then open and compile projects.

We need to collect the detailed compiled errors/warnings in the Error list or output windows, and then resolve them one by one even if we are not very sure that whether the VS2012 really supports it.

If it is hard for you resovled all errors, please tell us the real project type and development language, maybe we could provide you the specific development forum, so you could provide the detailed errors, I think the specific language developing experts could provide dedicated support. You could also share us the detailed error, we will provide the helpful information as we can.

Sincerely,

Jack

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Tuesday, November 17, 2015 8:18 AM

Hi ITBobbyP,

Do you have tried Jack's suggestion and what is that result? Please tell us the tried result to help us troubleshoot this problem one by one.

If you have solve the problem, please share your solution here or mark the helpful reply as answer, which is benefit for other communities who has the same problem.

Best Regards,
Weiwei

Wednesday, November 18, 2015 1:07 AM

Hi ITBobbyP,

I'm glad that you can reference your  SSIS now. Form the purposes you posted in the origin post, you have resolved your problem. Thanks for sharing your solution here. Please mark your reply as answer, which can help other communities who has the same problem.

Best Regards,
Weiwei