Data Flow Task Failing due to Nvarchar max column in Source and destionation

• Re1

  SSC Eights!

  Points: 991

  More actions

  February 12, 2016 at 9:09 am

  #311425

  Hi friends,

  I am getting an error while running an Data Flow task.

  [OLE DB Destination [2]] Error: An error occurred while setting up a binding for the "column_name" column. The binding status was "DT_NTEXT".

  Please advise.

  --

  Thanks and Regards,

  Re1

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  February 13, 2016 at 9:21 am

  #1858585

  Please post both source and destination table definitions as well as the complete error message or an SSIS Package that shows the behavior.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato