April 16, 2013 at 12:18 pm
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
April 16, 2013 at 12:36 pm
Can you load your data from a CSV file rather than Excel? Things will work better if you can change your source.
Is your column really called Column_Name?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
April 16, 2013 at 3:52 pm
No i am not able to change the source.
column_name is not the name of the column, it just mentions the name of the column that is in the source.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply