0

What is the process for importing an SSIS package from a server to an SSIS project in Visual Studio 2019?

edit

• ssis
• package
• server

asked 2021-12-16 11:00:00 +0000

pufferfish
41 ●3 ●2

edit retag flag offensive close merge delete

add a comment

1

answered 2021-05-13 10:00:00 +0000

plato
56 ●5 ●5

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.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss