I don't know if you ever got it worked out but i faced a project like this in my new job and the BIDocumenter is a tool i used to document the already existing SSIS packages.
My challenge is finding a tool that can create a stored procedures and tables column mapping document that will display all the transformations that were involved in the process.
so for example i have a client file ---> staging table ---> production and
---> = stored procedures
i have like hundereds of these is there a way of documenting the column mapping and transformations involved
Thank you.