• er.deepikagoyal (10/4/2013)


    Hi,

    Yes i am able to export my data. BCP uses format to export the data using comma separated.

    I have to define each column name to export the data with proper delimiter.

    This is an issues since i don't know my column name.

    If you have any other way around then let me know. i don't work on reporting services.

    Can anything be done through TSQL or SSIS.

    Regards,

    Deepika Goyal

    Do you mean you want the first line of the output to be column names?

    Is this the same as http://www.sqlservercentral.com/Forums/Topic1501526-391-1.aspx ?

    Far away is close at hand in the images of elsewhere.
    Anon.