Change column order in Flat File Destination

Question

Change column order in Flat File Destination

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

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

krichardson 80871 Newbie Points: 1 More actions · Answer 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: 246960 More actions · Answer 2

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Yeatsie SSC Rookie Points: 27 More actions · Answer 3

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 · Answer 4

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