locked
SSIS Documenter RRS feed

  • Question

  • Is there a decent tool out there to document SSIS Package?
    Monday, August 23, 2010 9:49 PM

All replies

  • You might want to try Pragmatic Works' BI Documenter.  I don't know of any others, offhand.
    Todd McDermid's Blog Talk to me now on
    Monday, August 23, 2010 10:40 PM
  • My take on BI Documenter: http://www.bimonkey.com/2010/08/bi-documenter-from-pragmatic-works/
    James Beresford @ www.bimonkey.com
    SSIS / MSBI Consultant in Sydney, Australia
    SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex
    Tuesday, August 24, 2010 6:05 AM
  • Well, there is the tool SSIS Documenter .  But, after having run the demo version of Pragmatic Works' B.I. Documenter in parallel with SSIS Documenter (our company actually has licenses for this product), I'd go with BI Documenter!

     

    * This is my personal opinion and is not meant to reflect any opinion of my employer or others!


    Please mark answered posts. Thanks for your time.
    Tuesday, August 24, 2010 2:42 PM
  • I had better luck with ApexSQL Doc than BI Documenter although both products had fairly serious flaws (last fall's evaluation).
    Tuesday, August 24, 2010 6:16 PM
  • Don't forget the free toolkit. Requires some tinkering and additions but does the basics.

    http://sqlmetadata.codeplex.com/


    SQL Server UE team
    Tuesday, August 24, 2010 8:50 PM
  • I had better luck with ApexSQL Doc than BI Documenter although both products had fairly serious flaws (last fall's evaluation).


    Steve -- I'd love to hear what the flaws were and if we've addressed them in the latest release. We made some MAJOR improvements in the SSIS documentation and added some pretty cool features.

    Shoot me an email - crock at pragmaticworks.com if you have a few minutes!


    Program Manager / Developer - PragmaticWorks

    Convert DTS to SSIS | Easy SSIS | SSIS Performance | Database Documentation
    Thursday, August 26, 2010 7:43 PM
  • The documentation for the free toolkit reads like the schematic for a small nuclear device...

    I've been trying for two days to figure out just how this thing works and am no closer. All I want to do is put to a folder in the MSDB store and generate some documentation.

    In my opinion, the free toolkit is practiacally impossible to understand...


    A. M. Robinson

    Friday, September 6, 2013 3:51 PM
  • I managed to find the following website:

    http://www.elsasoft.org/

    Their tool is pretty good. It documents database objects SSAS objects, SSIS packages, etc. and generates a compiled HTML help file. Granted, it's not a word document or a PDF but what is nice is that you get an index and it's searchable/portable and pretty thorough!!


    A. M. Robinson

    • Proposed as answer by ansonee Tuesday, September 17, 2013 6:56 PM
    Tuesday, September 17, 2013 6:56 PM