Editing a Fixed Format import

• thgamble1

  Ten Centuries

  Points: 1272

  More actions

  April 9, 2004 at 10:15 am

  #60071

  I'm wondering if there is a method to get back to the view for a fixed format import when trying to change column lengths.

  What I've done is the following:

  1200 character fixed format import and I messed up at around character 950 and began putting columns in "out of place"  I'd like to go back through and fix this via the graphical view rather than through T-SQL statement if possible.

  Anyonw know of a good way to do this?

  Thanks in advance

• jfb

  SSCrazy

  Points: 2519

  More actions

  April 12, 2004 at 9:24 am

  #502424

  Hi, to perform this, you need to go to the Transform Data Task Properties (black line) --> tranformations --> Edit.

  JFB