Post reply

Column Header Upper CASE SSIS

  • March 22, 2012 at 6:19 am

    #270527

    Hi

    I am new i SSIS , i want to get the pahysical_table result in faltfile destination , In the column heder comes in small case but i want All uppercase Column name in my output text file

    any one help to fix the problems

    Thanks;

  • March 22, 2012 at 6:23 am

    #1462645

    If your source is a SQL Server table, just use the UPPER function in your T-SQL query.

    John

  • March 22, 2012 at 6:33 am

    #1462652

    Hi;

    Thanks for replay , but I want only column name come in Upper not for the entire result sent.

    Hence I using the upper function all entire data come in upper case but i want only column name in upper case format.

    Example

    COLUMN_1 COLUMN_2

    01 john

    02 sample

  • March 22, 2012 at 8:13 am

    #1462735

    How are you selecting the data and the header?

    Do you use a query somewhere?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply