dbTalk Databases Forums  

Documenting DTS Packages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Documenting DTS Packages in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Satish Balusa
 
Posts: n/a

Default Documenting DTS Packages - 05-11-2005 , 03:35 PM






I have inherited fe DTS jobs without any documentation.
Is there a way I can generate documentation or an easy way to document it?
How do I figure out the starting point of a DTS package?

Any pointers / info is appreciated.

TIA
~Sat



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Documenting DTS Packages - 05-11-2005 , 04:10 PM






There is no easy way and I do not know a tool that does this. There
used to be one by a company that is no longer findable.

You will need to walk the object model to find things out about your
package(s)



"Satish Balusa" <sbalusaN0_SpaM (AT) corillian (DOT) com> wrote


Quote:
I have inherited fe DTS jobs without any documentation.
Is there a way I can generate documentation or an easy way to document it?
How do I figure out the starting point of a DTS package?

Any pointers / info is appreciated.

TIA
~Sat


Reply With Quote
  #3  
Old   
Mike Gercevich via SQLMonster.com
 
Posts: n/a

Default Re: Documenting DTS Packages - 05-12-2005 , 10:21 PM



Yes, there is... I have written a utility that will extract DTS Packages to
either .txt (with a multi-extract option) as well as color coded HTML.
Offers some configurable options on the output. This utility requires the
..net framework and the DTS DLLs to be installed on your workstation.

If you are interested, shoot me an email at mgercevich_nospam (AT) gmail (DOT) com
(remove the _nospam)

Hope this helps,
-Mike Gercevich

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.