How can I view the defintion of the ssisdb project stream fetched from SSISDB.internal.get_project_internal stored procedure?

Viola Rodrigues 0 Reputation points
2024-02-08T12:52:11.3466667+00:00

I have access to SSISDB database but not to the project saved in Integration Services Catalog. So I cannot view the project definition. Is there a way I can use the binary stream returned by the stored procedure SSISDB.internal.get_project_internal to read the project defintion?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,406 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points
    2024-02-09T02:35:45.6466667+00:00

    Hi @Viola Rodrigues,

    What do you mean of the ssisdb project stream?

    If you simply run below code, could you get the information you need?

    select * from catalog.projects 
    
    

    Regards, Zoe Hui


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


  2. ZoeHui-MSFT 30,411 Reputation points
    2024-02-09T06:20:05.9233333+00:00

    Hi @Viola Rodrigues, Please check below code to see if it is what you want.

    select
    name
    ,cast(cast(packagedata as varbinary(max)) as xml) as PackageData
    from [dbo].[sysssispackages]
    
    
    

    See https://blueskybi.wordpress.com/2014/03/18/querying-ssis-packages-from-sql/ Regards, Zoe Hui


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