Change column order in Flat File Destination

  • 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.

  • 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 you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • I just tried this method (creating a stubb file with just the column headers) and it fixed the order for me, thanks.

  • I just tried this method (creating a stub file with just the column headers) and it fixed the order for me, thanks.

Viewing 4 posts - 16 through 18 (of 18 total)

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