October 8, 2013 at 4:16 pm
Is there any tool free/paid/trial, which can automatically generate documentation for SSIS projects or just selected parts of the package ? For SQL server we have the awesome RedGate. Do we have anything like that for SSIS ? I saw one tool, but not sure if it is as good as the "standards" set by RedGate - http://stackoverflow.com/questions/1678907/tools-to-document-ssis-workflows
An example of what I expect -
Say I want to document only one package. It just copies one table (with column names) from an OLE DB source to a flat file.
I want the documentation for this package to contain -
> The settings of OLE DB source
> Settings of connection manager (You can hide passwords or server names if you wish or even replace them by aliases in the generated documentation)
> A sample of what the source table looks like i.e preview (columns, sample rows). It would be great if i could also choose to get the documentation (schema, tables, columns, column metadata, related tables etc) for the table as well.
I know this is asking a lot. But, it would be great to have this. Could there be any strong need (for work or commercial) for such a tool/add on to SSIS ?
October 9, 2013 at 1:00 am
Pragmatic Works has a documenting tool, but it is not free.
http://www.pragmaticworks.com/Products/BI-Documenter.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 9, 2013 at 12:20 pm
Koen Verbeeck (10/9/2013)
Pragmatic Works has a documenting tool, but it is not free.
Thank you very much for that. It looks like what I need.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply