SSIS - Bulk Insert Data Import Question

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  September 11, 2009 at 1:28 pm

  #226005

  When running a bulk insert process via SSIS, if an imported field is larger than the receiving field, will the SSIS process error and terminate, or will the receiving field be truncated and the SSIS process continue ?

  Thanks

• MannySingh

  SSChampion

  Points: 12465

  More actions

  September 11, 2009 at 2:02 pm

  #1052549

  The SSIS will throw an Error.

  Maninder
  www.dbanation.com