SSIS Documentation Features
|Top Previous Next|
SSIS Documentation Features include performance recommendations, workflow images, granular level documentation of all executables and more.
BI Documenter will document package executables, connection managers, variables and configurations along with the full source (dtsx) of an SSIS package.
feature for SSIS was developed by SQL Server MVP's to alert BI Documenter users
of potential performance issues within their SSIS packages.
Control Flow Diagram
BI Documenter will
capture the workflow for a package and store it as an image. This makes it very
easy to refer to the documentation at a later date to review changes that have
been made since the documentation was produced.
Control Flow Diagram lists the following items
- Precedence Constraints
- Expression on Variables (Red circle on variable icon)
- Expression on Tasks (Red circle on task icon)
- Expression on Connection (Red circle on connection icon)
Data Flow Diagram
SSIS Package documentation also captures individual dataflow screenshots so you can visually see the steps inside dataflow just like you can see in
SSIS Package Designer (DataFlow Tab).
Data Flow Diagram lists the following items
- Path Names (Only in certain cases e.g. Conditional Split, SCD Transform)
SSIS Documentation lists column mappings for each components inside dataflow so you can easily see mapped and unmapped columns for each components.