Globaly view DTS connections

Question

Post reply

Globaly view DTS connections

Kenneth.Fisher

SSC-Insane

Points: 20396
More actions
August 15, 2007 at 1:43 pm

#76757

I'm trying to find every DTS package on one of my servers that looks at a given server.
Does anyone know how to look at the connections from a global level?
Thanks
Ken
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Erik Kutzler SSCarpal Tunnel Points: 4287 More actions · Answer 1

I think you might be able to take what's in this article and modify it to suit your needs:

http://www.dbazine.com/sql/sql-articles/larsen8

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 2

Thank you very much!

Probably one of the coolest scripts I've ever seen (that I didn't write myself of course). The shell from that will let me do ALOT of things I've had to write VB to do before.

Thanks again

Ken

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 3

Ok the code works great. On 2 of the 5 servers I'm running it on. On the other 3 I'm getting the error " A dynamic link library (DLL) initialization routine failed." from the sp_OACreate sp. I've tryed re-registering each of the DLL's with "dts" in the name but it hasn't helped.

Any suggestions?

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

steve smith-401573 SSChampion Points: 10889 More actions · Answer 4

Are there version differences between the 5 servers? missing updates or special patches? As always, verify permissions are valid?

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 5

The only difference I have been able to find is that the ones that work are on Windows 2003 and the others are on Windows 2000. I have sysadmin rights on all 5.

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]