Package Permission Error with SSIS upgrade to SQL 2008

  • Hello,

    I am trying to upgrade my SQL 2005 SSIS packages to 2008. When I open the package in VS 2008, it runs through a conversion script and reports a list of warnings and errors. I have now worked through the list and eliminated all of the errors, but right before it opens the package in VS, it gives the error:

    "[Package Name] cannot be converted because it cannot be modified. To convert the solution, change the permissions on the solution to allow modification and re-open it."

    Does anyone know where I can change the package permissions to allow this to be opened? I have no permission errors in VS 2005 and I can make changes to the package without any issues.

    Thanks for any thoughts on this!

    Mark

  • Ok, I opened a ticket with MS to resolve the issue. The problem is really this -- 2005 solutions do not upgrade to 2008 (or perhaps this is the case only for some solutions). When you open the solution in VS 2008, it is unable to save the changes to the solution, however, it will modify the dtsx file.

    The work around is to simply to create a new solution in 2008 and then add your 2005 dtsx packages to that - Right click in the solution explorer and add existing package. I even had success doing this with packages directly from the 2005 server. In fact, it does not seem that you even need to run any wizards at all -- it will bring in all the components (and kill all of your scripts -- beware that those will need to be rewritten).

    I hope this saves some time for folks migrating their SSIS packages,

    Mark

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

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