This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 35%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
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?
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.
That does not provide the project structure/definition.
When we open the .dtsx file in a text editor, the package definition is displayed in XML format. Is it possible to obtain a readable version of this package definition from the stream returned by the stored procedure SSISDB.internal.get_project_internal? Is there any other stored_procedure I can use to get the definition.
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.
I want something similar in SSISDB. The casting doesn't work for project in SSISDB. I get the readable xml format for the package stream in the table you suggested, But it is in msdb database which contains only system packages.