SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Search DTS Package


Search DTS Package

Author
Message
ramadesai108
ramadesai108
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8535 Visits: 690
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?
sunshine-587009
sunshine-587009
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7673 Visits: 1288
Did you try checking the logs?

¤ §unshine ¤
ramadesai108
ramadesai108
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8535 Visits: 690
Thank you Sunshine. I could not find it in the logs.
SQL ORACLE
SQL ORACLE
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23437 Visits: 1314
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.
Greg Charles
Greg Charles
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: General Forum Members
Points: 36980 Visits: 6242
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
ramadesai108
ramadesai108
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8535 Visits: 690
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.
BP-503183
BP-503183
SSChasing Mays
SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)

Group: General Forum Members
Points: 633 Visits: 994
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.
MANU-J.
MANU-J.
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25772 Visits: 8766
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.
BP-503183
BP-503183
SSChasing Mays
SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)SSChasing Mays (633 reputation)

Group: General Forum Members
Points: 633 Visits: 994
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.
Attachments
Extract DTS_vb.txt (225 views, 11.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search