Import data from csv file to SQL Server 2005 - conversion from DT_I4 to DT_I2 is not supportive

• Loner

  SSC-Insane

  Points: 21279

  More actions

  August 29, 2008 at 10:34 am

  #123168

  I went to advance editor and changed the column type to both DT_I4. But it seemed the system automatically reset it.

  Can anyone help me with that?

• thasteve

  SSCrazy

  Points: 2707

  More actions

  August 29, 2008 at 11:57 am

  #865180

  it does most likely reset because the output of the task that flows into this is different data type