SSIS – DEPLOYED SSIS PROJECTS VERSIONS AND RESTORE TO PREVIOUS VERSION

Good thing in Project Deployment Model is we can store multiple versions of SSIS projects inside SSISDB. And also if we want to rollback to previous versions of deployed packages, we can simply restore to desired version. To see the previous versions of deployed projects, just right click on project and choose Versions 

























Then it will lunch you another window like below, then we need to choose which version we need to restore and click on Restore to Select Version, then it will give you another Confirmation window and then click on Yes. After that it will restores to selected version

























author

Kiran Reddy A

Kiran has been a part of the IT industry for more than six years and Involved in many MSBI projects and product development with extensive usage of ETL and Reporting tools like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS) and T-SQL

Get Free Email Updates to your Inbox!

www.CodeNirvana.in

Powered by Blogger.

Translate

Total Pageviews

Copyright © Journey to MSBI World With Kiran Reddy | Blogger Templates | Designed By Code Nirvana