Reputation: 1
I have done a project for data migration and transformation on a clients database and I need to show them what exactly I have done and what the columns map to etc.
I cant find a tool to do the documentation for me ? If i have to do this manually it will take me days if not weeks.
Upvotes: 0
Views: 2082
Reputation: 61211
The only documentation tool I am aware of is Pragmatic Work's BI Documenter. It builds out Windows help files (.chm) or HTML extracts. It's a clever product.
I was looking for a similar product 4ish years back and that was the only COTS product I had found. There was a dead project on... Codeplex I think. Otherwise, you can have fun enumerating through the objects in the package with the API. If you go that route, you can get some free rep by answering this question. Extracting SQL statements from a SSIS/DTSX package
Upvotes: 1