SSIS project documentation

  • Hello,

    My ssis project is almost done. Now we heading 2wards documentation .

    Could any one give me suggestions,guidelines.tools,samples or ideas

  • My company has a product called BI Documenter that will document your SSIS projects.

    Check it out and let me know what you think

  • You can create an excel file with separate sheets for easch package and paste a screenshot of your package then below that expalin what every task does.

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • Some of the most important things of the ETL that you must document:

    * data mapping (given a certain output column, which are the contributing input columns)

    * information liquidity model: describes the "flow" of the data through the whole ETL process

    Powerdesigner (a data modelling tool) has the capabilities to document this in great detail (even create the deployment scripts for the databases), but it is a rather complex tool.

    And of course, your code should document itself. Add annotations in your package, add in line comments in your T-SQL and .NET code.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks chrisrock

    I will let you know after i use this tool ..

  • Thanks for the replies with sugestions friends

  • @chisrock:

    I tried using the tool after downloading a free trail but it doesn't lemme do any thing unless i buy that...

  • Here is one more Tool to document ssis packages

  • Personally I love ApexSQL products. They have one called ApexSQL Doc.

    This will document the entire database including any objects, ssis, ect.

    You can select the databases, tables, functions, SPROC's, SSIS, ect that you want or don't. It includes text documentation, UML, relationship diagrams; and so-on.

    Very Very good stuff.

    http://www.apexsql.com

    <hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh

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

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