sql server data type.

• light_wt

  Ten Centuries

  Points: 1023

  More actions

  October 12, 2011 at 6:55 am

  #249869

  i have a column that is varchar(100) iso_1.

  it is having trouble to accept a column from a flat file. i was thinking of using data conversion to change the destination data type before it is making to the column in the table as a OLEDB dest.

  After trying using most of the datatype in the data conversion, it is still giving me the same error.

  what's wrong and how to import it?

  is there a tutorial of a fool proof way to import flat file?

  thanks.

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  October 12, 2011 at 7:16 am

  #1393407

  Without more information, this is impossible to answer.

  Please post the full text of the error message you are receiving.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel