Change column order in Flat File Destination

• krichardson 80871

  Newbie

  Points: 1

  More actions

  March 7, 2019 at 8:09 am

  #2023832

  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: 247109

  More actions

  November 25, 2019 at 4:44 pm

  #3700656

  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.

  ---

• Yeatsie

  SSC Rookie

  Points: 27

  More actions

  January 31, 2024 at 12:18 pm

  #4370718

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

• Yeatsie

  SSC Rookie

  Points: 27

  More actions

  January 31, 2024 at 12:19 pm

  #4370719

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