Post reply

SSIS project documentation

  • August 26, 2010 at 12:37 pm

    #223117

    Hello,

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

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

  • August 26, 2010 at 8:52 pm

    #1212695

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

    Check it out and let me know what you think

    _______________
    Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring

  • August 27, 2010 at 1:41 pm

    #1213224

    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]

  • August 28, 2010 at 11:50 am

    #1213455

    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

  • August 30, 2010 at 8:13 am

    #1213744

    Thanks chrisrock

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

  • August 30, 2010 at 8:14 am

    #1213746

    Thanks for the replies with sugestions friends

  • August 30, 2010 at 8:28 am

    #1213757

    @chisrock:

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

  • May 2, 2011 at 11:53 am

    #1318625

    Here is one more Tool to document ssis packages

  • August 24, 2012 at 11:11 am

    #1529869

    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