Change column order in Flat File Destination

  • krichardson 80871

    Newbie

    Points: 1

    I have tried to update the XML code to reorder the columns but it just rearranges them back to the original order.  This is very frustrating.  It seems like I have to go out of my way to order the columns and it is nearly impossible.

  • Phil Parkin

    SSC Guru

    Points: 244656

    I've just been through this pain too ... VS2017 and still no easy way to re-order columns in a destination file.

    Creating a blank file in the required format (just headers) & then refreshing the package metadata was my preferred method – better than painstakingly shuffling chunks of XML around.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

Viewing 2 posts - 16 through 17 (of 17 total)

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