Nothing is constant ,we usually gets so many change requests in our process with respect to Functionality, Performance and fix fixes .So we need to change our Packages according to new requirements. Once we changed our SSIS packages in Project and if we want to redeploy SSIS packages to same location in Integration Services Catalog, just right click on Project and choose Deploy option. Redeploying Packages is not different from deploying SSIS packages first Time.
After click on Deploy, it will launches the Integration Services Deployment Wizard. Just like deploying SSIS project first time, it will open Select Destination page and we can see warning about already existing of the project on the Integration Services Catalog, the rest of the steps remain the same as a deployment.
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!
1 comments:
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
ReplyMsbi Online Training India
Msbi Certifiacation Training