question

tlenzmeier avatar image
tlenzmeier asked

Retrieve Table Names From SSIS Packages

Hello,

I am trying to write a query that retrieves the names of the table(s) used in my various dtsx packages. Integration Services is running on a "normal" SQL Server instance (database engine). I've seen other examples that queried the MSDB, but that isn't relevant in my case. Presently, I am viewing the xml in Visual Studio, copying it, and pasting it into Notepad ++, which is rather tedious.

ssisxmlsql server 2016
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

SSISDB.catalog.packages should contain the xml.

Then you need to parse it out like you are doing in notepad.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.