Skip to Content
0
Former Member
Aug 16, 2013 at 01:56 PM

Source to Target Mapping Report

210 Views

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.