Hi all,
I have many DTS jobs that copy files to my SQL server and import them into
SQL tables. Is there a way to get a list of all jobs and what files they are
accessing?

TIA,
Joe

Hello jaylou,

Unless you do this a part of data lineage in your ETL packages then there
is no in-built way to do this out of the box. That said you can programmatically
go through all your packages and retrieve the properties of the text file
that you require. It is not as easy as you may wish but it will work.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com