Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL code for selecting source column names and target column names that are mapped and writing into a log file Expand / Collapse
Author
Message
Posted Monday, January 11, 2010 12:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 26, 2010 8:29 AM
Points: 113, Visits: 265
I have a scenario where i am mapping twp tables using a data integrator
In that package we have a source table and a target table and mapping are done from source table to target table.

My requirement is to create a log file which consists of mappings.
In that log file i just need column names (not values or data) in the way they are mapped

For example if column 1 in source table is mapped to column 25 of target table.
In the log file it should look like this

column 1 in source table is mapped to column 25 of target table

I need logic for this
Can anyone help me out
Post #845629
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse