SSIS pkgs not showing

Question

Hello,

I migrated some SSIS packages from instance A to Instance B where SSIS catalog and SSISDB is already there.

Now When i connect to SQL Server Instance B using Visual Studio, i cannot see the packges/projects...

Or if connect to SSIS on instance B, it still dont show any SSIS pacakages.. rather it shows only some pkgs which were in msdb on Instance A

Please help

Answer 1

Hi @Bilal H. Bhatt

According to your picture, you are storing packages in so called SSIS Catalog store. Adding packages to existing SSIS Visual Studio solution is possible only for packages stored in MSDB.

To import packages from SSISDB, go to solution in the Visual Studio Solution Explorer, and choose Add New Project, then choose Integration Services Import Wizard.

You may import package which located in SSISDB like shown below.

You may also follow the video for details.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

I migrated some SSIS packages from instance A to Instance B

And how did you the migration; you haven't mentioned any detail about?

Answer 3

ssis_imprt.JPGI connected to Instance B --> Integration Service Catalog ---> Create Folder --> Right click --> Import Packages. Select the SQL Server and it will show all packages ..