Update SSIS package in SQL Server Management Studio to reflect recent changes

What's the easiest way to update an SSIS package that you have already imported into Management Studio after you've changed and saved your package in VS afterwards   I don't see an update option in VS or MS or something to allow me to move any changes I've made to that package into Management Studio.  When I execute the package from MS, it doesn't reflect my latest updates in VS to that package.

I figure there must be a way rather than have to reimport it back in manually to MS.




Answer this question

Update SSIS package in SQL Server Management Studio to reflect recent changes

  • harbars

    If you have imported a package to a server, it creates another copy at the server. The changes you make on the local copy on your file system will not reflect automatically to the package on the server. With your package open in Visual Studio, you can choose "Save copy of the package as" and save to the SQL Server with the same name as your old package, and it will ask whether you want to replace your package.

  • Update SSIS package in SQL Server Management Studio to reflect recent changes