Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Documentation templates for SSIS/DTS packages

1,767 views

Skip to first unread message

KarenM

unread,

Feb 13, 2009, 7:23:43 AM2/13/09

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

TheSQLGuru

unread,

Feb 13, 2009, 8:55:51 AM2/13/09

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" <karenm...@yahoo.com> wrote in message
news:7959e9cc-0cae-41b5...@u18g2000pro.googlegroups.com...

Jan Waiz

unread,

Feb 13, 2009, 9:02:18 AM2/13/09

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" <karenm...@yahoo.com> schrieb im Newsbeitrag
news:7959e9cc-0cae-41b5...@u18g2000pro.googlegroups.com...