I am working on a large data migration using SSIS. In past projects we have used SQL stored procedures and manually generated mapping spreadsheets to provide to the client. We have now been tasked with providing this type of documentation on the current project. I would have though that generating data flow mapping documentation would be something that SSIS would do "out of the box" similar to what I have seen from Informatica. I have yet to find any solutions to this issue, and wonder if anyone on this forum has run into a similar situation and how went about automating the documentation process?
thanks in advance.