SQL code for selecting source column names and target column names that are mapped and writing into a log file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » SQL code for selecting source column names...

SQL code for selecting source column names and target column names that are mapped and writing into a log file

Rate Topic

Display Mode

Topic Options

Author

Message

rahulsony111

Posted Monday, January 11, 2010 12:16 PM

SSC-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 »

Permissions