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
- export packages ssis package store files.
- 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
Post a Comment