Share via

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,462 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,386 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 33,386 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.