Post reply

Export data using SSIS to csv in 2008

  • June 30, 2011 at 8:59 am

    #252931

    Hi i'm exporting data using SSIS in SQL 2008 to a csv file, I need to put a header i.e. store name as header. is there a way to do this.

    Please help..:rolleyes:

    Fortune

  • June 30, 2011 at 9:51 am

    #1346638

    in the connection manager at the bottom of the screen, click on your file connection and then check the box 'column names in the first data row'

  • July 4, 2011 at 3:25 am

    #1347699

    Hi

    Thanx for the reply, i actually want to add a store name on the first line of the csv before the columns.

    e.g

    SPAZA (storename)

    ProductCode Price SHO VAT (columns)

    so when i export i will have the storename, then followed by the columns.

    Thanks

    4TOONE

  • July 4, 2011 at 4:33 am

    #1347726

    hi,

    i did something like this using Derived Column transformation

  • July 4, 2011 at 5:38 am

    #1347780

    Hi

    please provide example if you can.

    Thanx

    Fortune

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

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