is there an way to list the packages in ssis using java

Question

my requirement is to list the packages that are in the ssis using the java, please let me know if you guys have any idea

we can see using the Microsoft studio need those into my application dynamically

Answer 1

Where are packages stored in SQL Server?

Referring to Package Management documentation:

The sysssispackages table contains the packages saved to msdb database.

If you are using SQL Server 2012+ and you are deploying databases to the Integration Service catalog, then the packages are stored in SSISDB.

Connect to SQL Server using Java

You can simply do that by executing an SQL query (using java.sql) in Java:

• Java - JDBC Code Examples for MSSQL

SQL query to list SSIS packages stored in msdb

msdb version

You can use a similar query:

select * from msdb.dbo.sysssispackages

Or you can refer to the following link for an advanced query:

• How to list all SSIS packages on the Sql Server 2008 using T-SQL (SQL Server 2005/2008)

SSISDB version

SELECT 
    pk.project_id, 
    pj.name 'folder', 
    pk.name, 
    pj.deployed_by_name 'deployed_by' 
FROM
    SSISDB.catalog.packages pk JOIN SSISDB.catalog.projects pj 
    ON (pk.project_id = pj.project_id)
ORDER BY
    folder,
    pk.name

• Script - List all SSIS Packages in SSISDB Catalog (SQL Server 2012+)