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

  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.

  ---