Sometimes we need to edit the deployed SSIS packages, so to edit we need to open deployed .ispac in BIDS. We can open .ispac in two ways by using integration services import project wizard
By following steps, we can open import project
By following steps, we can open import project
1. Open Visual Studio, click on New à Project on the File menu.
2. In BIDS Installed Templates, Select Integration Services Import Project Wizard from the project types list.
3. Give Name for Project.
4. Specify the location where we want to save the newly created project and give Solution Name
5. Click on Next on Select Source page.
6. We can import .ispac from two ways i.e. a. Project Deployment File and b. Integration Services Catalog
If we want to import from an .ispac file, then we need to choose Project Deployment File type Click on Browse to the folder where .ispac is placed in Local Drive.
If we are importing .ispac from an Integration Services Catalog, then we need to specify next server name and Browse Integration Services Catalog and choose project and click on OK
7. Next it will lunch you, another review window and click on Import to create a project based on the existing project you selected.
8. Click on Close button to close the Wizard
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!
