Post reply

Columns order

  • May 14, 2009 at 8:22 am

    #131352

    In the OLE DB data source, I’m pulling few columns from the db for e.g. firstname, lastname, fullname. I would like to display the column in the specified order. In the db the columns are defined as firstname, fullname, lastname. When I'm outputting the results in a csv file the fields are displayed as they are defined in the db not the way it’s mentioned in the query. Is there a way to output the fields the way I've it in my query?

    Thanks in advance,

    Bhavna

  • May 14, 2009 at 8:29 am

    #994578

    you can manauly edit the data destination conneciton manager to change order of the columns, though this may take a while.

    An easier way is to delete the connection manager and create a new one based upon your query..

  • May 14, 2009 at 9:15 am

    #994618

    Thanks steveb! I ended up manually editing the fields.

    ~Bhavna

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

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