DTS package query -- how to

This is a discussion on DTS package query -- how to within the sqlserver-dts forums in Microsoft SQL Server category; I have a large number of DTS packages on my 2000 servers and need to catalog them all. Our developers omitted that step when they created them over time. Is there a way to query DTS packages so that I can get all of the configuration settings and code? Opening each DTS package individually and copying or doing screen shots would be a very long process, and I'm looking for a shortcut. Thanks, Moishe...

Go Back   Database Forum > Microsoft SQL Server > sqlserver-dts

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-20-2008, 12:50 PM
Default DTS package query -- how to

I have a large number of DTS packages on my 2000 servers and need to catalog
them all. Our developers omitted that step when they created them over time.

Is there a way to query DTS packages so that I can get all of the
configuration settings and code? Opening each DTS package individually and
copying or doing screen shots would be a very long process, and I'm looking
for a shortcut.

Thanks,
Moishe
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:48 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.