Parse DTSX Package Connection Manager Properties

The following query returns connection manager properties from the SSIS .dtsx packages stored in a particular file system folder. The code relies upon the undocumented and unsupported sys.xp_dirtree extended stored procedure that ships with all…