Is anyone aware of a way to generate a typical "Source to Target Mapping" report from a data movement model?
I am looking for something like this:
Source Table Source Column Source Datatype Transformation Target Table Target Column Target Datatype
------------------ -------------------- ----------------------- -------------------- ----------------- -------------------- ----------------------
Employee EMP_NO VARCHAR(10) pass-thru D_EMP E_NO VARCHAR(10)
I don't see anything out of the box that comes close to this. It seems to support listing the contents of each object, but no way to represent the logical flow of columns represented inside a DMM.