dbTalk Databases Forums  

Documentation templates for SSIS/DTS packages

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


Discuss Documentation templates for SSIS/DTS packages in the microsoft.public.sqlserver.dts forum.



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

Default Documentation templates for SSIS/DTS packages - 02-13-2009 , 06:23 AM






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

Reply With Quote
  #2  
Old   
TheSQLGuru
 
Posts: n/a

Default Re: Documentation templates for SSIS/DTS packages - 02-13-2009 , 07:55 AM






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

Quote:
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



Reply With Quote
  #3  
Old   
Jan Waiz
 
Posts: n/a

Default Re: Documentation templates for SSIS/DTS packages - 02-13-2009 , 08:02 AM



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...
Quote:
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


Reply With Quote
  #4  
Old   
Joe H
 
Posts: n/a

Default Re: Documentation templates for SSIS/DTS packages - 02-17-2009 , 09:38 AM



Here is one for $29

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


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

Quote:
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



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.