SQL Server Performance Forum – Threads Archive

How to generate source code from package in MSDB

I have a situation of generate XML source codes from the packages those are in MSDB thru batch scripts for dependency check of DB objects. Anyone knows how to ?
Or
Anyone knows how to check the dependecy of SSIS packages ? thanks, JB

---

Here’s what I found and it’s good enough for me to check the dependency. The PackageData in MSDB..SysDTSPackages90 table can be retrieved in two different ways as below; In XML
SELECT cast (cast (packagedata As varbinary (max)) as xml) FROM msdb..sysdtspackages90 where [name] = ‘Your Pkg Name’ In Varchar(max)
SELECT CONVERT(VARCHAR(MAX), CONVERT (VARBINARY(MAX), packagedata)) FROM msdb..sysdtspackages90 where [name] = ‘Your Pkg Name’ Tks, JB

---

]]>