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


  • 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

  • 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.



    Tuesday, October 08, 2013 8:57 AM