Hi,

I am working on a project which already have some procedures, SSIS Packages etc

There is very less documentation and I would like to create some documentation etc for easy understanding, reusability of the code

<g class="gr_ gr_130 gr-alert gr_tiny gr_spell ContextualSpelling multiReplace" data-gr-id="130" id="130">i</g> shall be thankful if anyone can share any templates etc

cheers 

Please refer : http://www.brentozar.com/archive/2013/01/documentation-it-doesnt-suck/

http://community.spiceworks.com/how_to/2753-general-document-template-for-sql-server-database

thanks a lot 

if any other document to show the code flow example procedures, packages etc

Hi NZ-D,

What source code of your project? You may get better support to post the question in the forum of your application.

In addition, to document and sequence SSIS packages, you can review this blog: SQL Server Integration Services (SSIS) Inline Documentation Methods.

There are also some similar threads for your reference.
documenting existing code
How to make a Documentation and sequence diagram for my existing C# source code


Thanks,
Lydia Zhang