Excel source Binding Status Error

• gurvimail

  SSChasing Mays

  Points: 615

  More actions

  April 16, 2013 at 10:59 am

  #276503

  I am trying to load the data from Excel sheet and its givinge me the following error;

  [OLEDBDestination - Error: An error occurred while setting up a binding for the "Column_Name" column. The binding status was "DT_TEXT".

  Since Exel uses the forst few rows to derive the data types , i had tried to make chages in the Advanced editor and then setting the datatypes for the External columns and the output columns , but still not working.

  In Excel sheet the first rows are of String type and in the destination table they are of TextStream(varchar(max)).

  so i need to make excel source think that the datatypes are of ntext type.

  any help will be apprecited.

  Thanks