Import an Integration Services Project
Applies To: SQL Server 2016
Use the Integration ServicesImport Project Wizard to create a project from an existing deployment file (.ispac) or from a project deployed to Integration services catalog. This feature is especially useful when you do not have the original copy of the project but you want to create one from an .ispac file or SSISDB catalog.
In Visual Studio, click New > Project on the File menu.
In the Installed Templates area of the New Project window, expand Business Intelligence, and click Integration Services.
Select Integration Services Import Project Wizard from the project types list.
Type a name for the new project to be created in the Name text box.
Type the path or location for the project in the Location text box, or click Browse to select one.
Type a name for the solution in the Solution name text box.
Click OK to launch the Integration Services Import Project Wizard dialog box.
Click Next to switch to the Select Source page.
If you are importing from an .ispac file, type the path including file name in the Path text box. Click Browse to navigate to the folder where you want the solution to be stored and type file name in the File name text box, and click Open.
If you are importing from an Integration Services Catalog, type the database instance name in the Server name text box or click Browse and select the database instance that contains the catalog.
Click Browse next to Path text box, expand folder in the catalog, select the project you want to import, and click OK.
Click Next to switch to the Review page.
Review the information and click Import to create a project based on the existing project you selected.
Optional: click Save Report to save the results to a file
Click Close to close the Integration Services Import Project Wizard dialog box.