Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version
  1. Open Visual Studio 2019 and create a new Integration Services (SSIS) project.
  2. Right-click on the Integration Services Catalogs folder and select "Connect to Integration Services Catalog" from the context menu.
  3. Enter the server name and login credentials to connect to the Integration Services Catalog on the source server.
  4. Once connected, expand the SSISDB node and locate the package you want to import.
  5. Right-click on the package and select "Export Package" from the context menu. This will open the "Export Package" window.
  6. In the "Export Package" window, choose a location to save the package and select the "File system" option.
  7. Click on "Export" to save the package to the specified location.
  8. In Visual Studio, right-click on the "SSIS Packages" folder in the Solution Explorer and select "Add Existing Package" from the context menu.
  9. Browse to the location where you saved the exported package and select it.
  10. Click on "Open" to import the package to the SSIS project in Visual Studio. The package should appear in the "SSIS Packages" folder in the Solution Explorer.