October 11, 2009 at 4:54 am
We have around DTS 300 packages in our Project .I need to list out
DTS packages which are directly inserting into table from the source file.
Do we have any system table in sql server2005 that contains that information ??
October 11, 2009 at 8:46 am
No, not so far as I know.
If your DTS packages implement logging, then you could check their logs.
Or if they each use a unique Login and you have auditing logs, then you could check those.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 12, 2009 at 9:51 am
If you don't have package logs or auditing, you'll have to script out all the packages and search for the table name. This script helps with that: http://www.sqlservercentral.com/scripts/Miscellaneous/31613/
Greg
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply