Export to a textfile is revers the columns

• Joel_sjoo

  Old Hand

  Points: 332

  More actions

  February 27, 2008 at 1:14 am

  #120308

  Hello. I have a problem with some some SISS packages that I have converted from DTS. Acually its only one off the packages that not work. I do a export from a select query to a textfile. The query return like:

  Xxx1;123213;name, name;Addess;number;Address;telephon;mail;17;1

  The problem is when it gos to the textfile. When I look in it its look like the column is reversed. Like this:

  1;17;mail;tlephone;Address;number;and so on….

  Anyone who now what it can be? I can not figure it out. The other packages that do about this package works ok.

  Kind Regard Joel

• SQLdevotee

  SSCarpal Tunnel

  Points: 4820

  More actions

  February 27, 2008 at 8:38 am

  #782566

  If you want a quick and easy way to solve this, pass it throgh Copy column or Sort transformation. Try doing this and you will understand what I mean. Usually doing things in SSIS from DTS creates a lot of impacts on the package. This may be one of them.

  [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  February 27, 2008 at 1:38 pm

  #782853

  I had a problem similar to yours, order of my Input columns[in table] did not match the order of my Output columns[ in TXT file].

  If this sound fimilar to your problem,this is what I did to solve it .

  Rearrange the columns order in my SELECT query and make sure the columns are mapped accordingly in Flat File Connection[by order]

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]