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.
Labels:
SSIS PACKAGE
I am Database Manager and available to work.
I have 13+ years of administration and Development experience in Microsoft SQL Server version 2000, 2005 / 2008 / 2012 / 2014 /
2016 / 2017 / 2019, 2022,
Azure Services, AWS Services,
Powershell Scripting, T-SQL Development,
SSIS, SSRS, PostgreSQL,
MySQL, MongoDB and ITIL.
Contact me on : jaiverma.hi@gmail.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment