Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Search DTS Package Expand / Collapse
Author
Message
Posted Thursday, March 13, 2008 7:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Hi All,
A DTS package runs on a schedule that inserts data into a table on another server. I know the name of the table but I do not know the dts that inserts/updates that data. So how do I search for a dts package that updates a certain table in sql server 2005?
Post #468711
Posted Thursday, March 13, 2008 8:17 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 25, 2014 11:53 AM
Points: 361, Visits: 1,169
Did you try checking the logs?

¤ §unshine ¤
Post #468751
Posted Thursday, March 13, 2008 8:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Thank you Sunshine. I could not find it in the logs.
Post #468769
Posted Thursday, March 13, 2008 8:53 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
I do not think you can get it directly. DTS packages are saved in binary code.
You may set a profiler, or trigger to see what processes are running when you table is modified.
Post #468785
Posted Thursday, March 13, 2008 9:16 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:51 PM
Points: 4,065, Visits: 5,298
If these are legacy DTS package, not SSIS packages, you can save them as VB files and search them with a text editor. There are scripts in the Script section of this site that will save all packages in an instance to files. Try searching for something like, "save as file".

Greg
Post #468807
Posted Thursday, March 13, 2008 11:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Thank you Greg. Yes the packages were created using SQL 2000. I was not able to find any script on this site to save the files, but I tried saving it to vbfile manually and that is a tremendous help. Thanks again.
Post #468940
Posted Friday, May 14, 2010 7:47 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:41 AM
Points: 332, Visits: 843
You can use .NET to read each of the DTS packages and create a summary of the package including connections and code using the Microsoft DTS Com objects. We create a directory for each sql server and put the DTS summaries there using txt extension.

Post #922033
Posted Friday, May 14, 2010 3:00 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
BP-503183 (5/14/2010)
You can use .NET to read each of the DTS packages and create a summary of the package including connections and code using the Microsoft DTS Com objects. We create a directory for each sql server and put the DTS summaries there using txt extension.



Could you please post the .NET code you are making use of for creating such a nice listing of dts package.
Post #922324
Posted Tuesday, May 18, 2010 6:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:41 AM
Points: 332, Visits: 843
I found some of this code online a couple years ago, I don't have the original authors name. I have modified over the years to work for our setup. The attachment is vb code in a text file.

  Post Attachments 
Extract DTS_vb.txt (121 views, 11.13 KB)
Post #923502
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse