BI Documenter - John Dempsey
"BI Documenter allowed me to document not only the database objects, but SSIS, SSRS, and SSAS too. This is a great benefit. It provided access to their metadata database repository the software used which I felt was a big plus. A must have tool."
John Dempsey
BI Documenter - VCU Health System
"The time and effort BI Documenter saves my team by documenting the entire BI stack is priceless."
Carlos Dickens

Manager, Data Warehouse

VCU Health System

BI Documenter - Microsoft
"I'd say you have a very impressive and extremely useful product here. I highly recommend [BI Documenter] to anyone who wants to take snapshots of their SQL Server BI solution... Cool product."
Kirk Haselden

Development Manager

SQL Server Integration Services, Microsoft Corporation



Buy Now Free Trial Download Free Live Demo!                        
SSIS Package Documentation

BI Documenter allows you to quickly develop an overview of your Integration Services Packages. Visually displaying the control and data flow as well as properties and expressions used for each component, variable, and connection manager.

Feature Highlights:

  • Display recommendations and alerts for potential performance related issues
  • Easily recreate SSIS Packages using the full Package Definition (dtsx) that is captured and displayed by BI Documenter
  • Visually captures and displays the Control and each Data Flow within your SSIS Package
  • Quickly identify mapped and unmapped columns for each component using BI Documenter’s column
  • Document both package and task level event handlers as well as which variables are being used within those event handlers
SSIS Package Documentation

SSIS Package Documentation step 1

All Major SSIS Packages Documented!

  • BI Documenter allows users the ability to document SSIS Packages across all major versions of SQL Server: 2005, 2008, 2008 R2, and 2012. Additionally, BI Documenter also supports the documentation of SSIS 2012 Packages that are stored within the new Package Catalog (SSISDB) introduced in SQL Server 2012.

All Major SSIS Packages Documented!

  • BI Documenter allows users the ability to document SSIS Packages across all major versions of SQL Server: 2005, 2008, 2008 R2, and 2012. Additionally, BI Documenter also supports the documentation of SSIS 2012 Packages that are stored within the new Package Catalog (SSISDB) introduced in SQL Server 2012.

SSIS Package Documentation step 2

Best Practice Analyzer

  • Developed by SQL Server MVPs, BI Documenter’s Best Practice Analyzer displays recommendations and alerts for potential performance related issues within an SSIS Package. This list of recommendations includes configuration files, OLE DB Command usage, column sort orders, and more.

Best Practice Analyzer

  • Developed by SQL Server MVPs, BI Documenter’s Best Practice Analyzer displays recommendations and alerts for potential performance related issues within an SSIS Package. This list of recommendations includes configuration files, OLE DB Command usage, column sort orders, and more.

SSIS Package Documentation step 3

Full Package Definition (DTSX) Documented

  • Easily recreate SSIS Packages using the full Package Definition that is captured and displayed by BI Documenter.

Full Package Definition (DTSX) Documented

  • Easily recreate SSIS Packages using the full Package Definition that is captured and displayed by BI Documenter.

SSIS Package Documentation step 4

Control Flow Diagram

  • BI Documenter captures and displays the Control Flow for an SSIS Package and stores it within the documentation. This makes it very easy to refer to the documentation and review changes that have been made since the documentation was produced. Included within the control Flow Diagram are the following items:
    • Tasks
    • Variables
    • Connections
    • Precedence Constraints
    • Expressions on Variables (as a red circle in lower left corner)
    • Expressions on Tasks (as a red circle in lower left corner)
    • Expressions on Connections. (as a red circle in lower left corner)

Control Flow Diagram

  • BI Documenter captures and displays the Control Flow for an SSIS Package and stores it within the documentation. This makes it very easy to refer to the documentation and review changes that have been made since the documentation was produced. Included within the control Flow Diagram are the following items:
    • Tasks
    • Variables
    • Connections
    • Precedence Constraints
    • Expressions on Variables (as a red circle in lower left corner)
    • Expressions on Tasks (as a red circle in lower left corner)
    • Expressions on Connections. (as a red circle in lower left corner)

SSIS Package Documentation step 5

Data Flow Diagram (Not supported in SQL Server 2012 yet)

  • Much like the Control Flow Diagram, BI Documenter also captures and stores each individual Data Flow found within an SSIS Package. Included within the Data Flow Diagram are the following items:
    • Components
    • Paths
    • Path Names (where applicable)

Data Flow Diagram (Not supported in SQL Server 2012 yet)

  • Much like the Control Flow Diagram, BI Documenter also captures and stores each individual Data Flow found within an SSIS Package. Included within the Data Flow Diagram are the following items:
    • Components
    • Paths
    • Path Names (where applicable)

SSIS Package Documentation step 6

Column Mappings

  • BI Documenter includes a detailed list of the column mappings inside of each Data Flow of an SSIS Package. This allows you to quickly identify mapped and unmapped columns for each component.

Column Mappings

  • BI Documenter includes a detailed list of the column mappings inside of each Data Flow of an SSIS Package. This allows you to quickly identify mapped and unmapped columns for each component.

SSIS Package Documentation step 7

Event Handler Documentation

  • BI Documenter allows you to quickly and easily determine what events are present within an SSIS Package. This includes the documentation of package and task level event handlers as well as the variables being used by the event handlers.

Event Handler Documentation

  • BI Documenter allows you to quickly and easily determine what events are present within an SSIS Package. This includes the documentation of package and task level event handlers as well as the variables being used by the event handlers.

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works