Hi All,

Can any of you kindly point me to some URLs for templates for
documenting SSIS/DTS packages and templates for documenting the
database objects like stored procedures & tables/views

Thanks
Karen

I highly recommend ApexSQL's Doc program.

DISCLAIMER: I have a very close relationship with ApexSQL. I use and
recommend their products to my clients. If you care to you can get a
discount (and I can get a small remuneration) if you tell them TheSQLGuru
sent you.


--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote

Hi Karen,

hm. I think the best template is the one inside your head :-)

I use a normal word document well structured in main points like

1. Overview
2. Stored Procedures
3. Packages
3.1 MyWorkingPackage
3.1.1 Control Flow
3.1.2 Data Flows
3.1.2.1 ThisDataFlow
3.1.2.2 ThatDataFlow
....

where i document all the stuff. And: i use the "snipping tool" to generate
fast "screen shots" of the packages as you build them inside BIDS. Also a
small annotation beside each task descriping in one or two sentences what he
task is doing.

hth
Jan Waiz

"KarenM" <karenmiddleol (AT) yahoo (DOT) com> schrieb im Newsbeitrag
news:7959e9cc-0cae-41b5-8f90-e959044f5a13 (AT) u18g2000pro (DOT) googlegroups.com...

Here is one for $29

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


"KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote