Friday, 21 February 2020

How to take a copy of already deployed SSIS package for reference of new package/testing etc

Go to SSMS --> SSIS integration catalog --> right click on deployed package --> Export --> Save --> go to save location --> rename save file in dot zip format i. e. abc.zip  --> now extract the zip file --> Now open BIDS--> open the file package in BIDS. 

No comments:

Post a Comment