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 versions of Microsoft SQL Server. To use this code, you’ll need to be a member of the sysadmin server role.

A girl reads to a convalescent while a nurse brings in the patient's medicine. R.H. Giles

A girl reads to a convalescent while a nurse brings in the patient’s medicine.
R.H. Giles

Thanks for reading, and while you’re here, why not check out the rest of our free SQL Server Tools!


If you found this post useful, please
consider donating a small amount
to help keep the lights on and site running.