Sign in
 

none
Need to write a query to use column values as a column name.

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Required dynamic query for each client.

    I have two CSV files - one is look up and another is fact. I want to extract the respective column alias from look up file and want to use column alias value as column name in table. Following are the screen shot for the files

    Saturday, October 05, 2013 8:11 PM
    |

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Ricky,

      Could you explain a bit more in details by use an example?

    PS: although it's part of the ETL, i think it would be more suitable for transfer this question to SSIS section.

    Regards

    Stephen

    Tuesday, October 08, 2013 8:57 AM
    |