I have an SSIS package and I have enabled logging. I need to query the package and have it list all of the steps that are in the package. The sysssispackages table and the sysssislog is not very transaparent about how this could be done. has anyone here taken this on?
I have never attempted this, but based on your post you are storing the packages in the msdb database. The sysssispackages table contains the column package data which contains the actual package. Again I have not attempted to do this, but you could convert the package data to XML and then shred the XML to extract the tasks. This query will convert the package data to XML: SELECT CONVERT(XML, CONVERT(VARBINARY(MAX), packagedata)) AS pkg FROM msdb.dbo.sysssispackages