sql - Find all Packages that uses Flat Files -


one of coworkers wondering if there way list of ssis packages names on integration services of packages uses flatfiles. there lot of packages on server , take long time find packages manually. using sql 2008 r2.

thank you

  1. export packages ssis package store files.
  2. search in .dtsx files <dts:property dts:name="creationname">flatfile</dts:property>. integral part of flat file connection manager definition.

note - applies 2005 , 2008 packages only!


Comments