August 25, 2011 at 11:38 am
With Informatica, you graphically trace a particular column from source, through various transformations, all the way to the destination. You can also go backwards. Is there a tool out there that can do something similar for SSIS?
August 25, 2011 at 12:11 pm
imani_technology (8/25/2011)
With Informatica, you graphically trace a particular column from source, through various transformations, all the way to the destination. You can also go backwards. Is there a tool out there that can do something similar for SSIS?
You can add DataViewers between components in a data flow to view the data as you run a package. I've never used Informatica, but this should be similar enough to what your describing from Informatica.
August 25, 2011 at 12:17 pm
Thanks, I already know about data viewers. I was just wondering if there was tool that literally shows the line backwards from the the destination column back to how it came to be.
September 16, 2014 at 6:55 pm
InfoLibrarian provides full end to end dynamic lineage in a web portal even beyond Relational,SSIS,SSAS,SSRS
for example:
Code , processes and applications.
There's a free evaluation to try.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply