Document DTS''

Question

Document DTS''

Joe Contreras

Ten Centuries

Points: 1341
More actions
June 29, 2006 at 8:19 am

#70908

I'd like to know if there's a tool that documents a DTS package and builds some type of report.

Thanks,

Viewing 8 posts - 1 through 7 (of 7 total)

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

MannySingh SSChampion Points: 12465 More actions · Answer 1

Well, that depends on what you want to document. For error or Step Logging you can create a Log File form Package Properties. Or Query system Tables in MSDB(sysdtspackages/sysdtscategories/sysdtspackagelog/sysdtssteplog/sysdtstasklog/) for Related information on DTS Packages.

Maninder
www.dbanation.com

Joe Contreras Ten Centuries Points: 1341 More actions · Answer 2

I do have error handling and track logs, however what I'm trying to accomplish is documenting the physical DTS package, the different steps associated within the DTS package. For Application Documentation.

Thanks,

rmcknight SSC Eights! Points: 918 More actions · Answer 3

You can save as a basic file and mark up the .bas file in document editor. Not so automated, but gets you part way there.

Filet SSC Enthusiast Points: 184 More actions · Answer 4

There is a list of DTS documentation products and other useful DTS tools at http://www.sqldts.com/default.aspx?401

Cheers

Filet

Peter Kuzniewski SSC-Addicted Points: 418 More actions · Answer 5

The best tool I've found is called DTSDoc, you can find details at http://www.dtsdoc.com. The price is right, too - $39.95!

Peter

Joe Contreras Ten Centuries Points: 1341 More actions · Answer 6

Thanks everyone for responding. This has helped greatly.

patil SSC Enthusiast Points: 153 More actions · Answer 7

Try the DTS Documenter:

http://www.softrus.org/dts/

It might save you a lot of time.