What is DBBINDSTATUS_UNSUPPORTEDCONVERSION

Question

An error occurred while setting up a binding for the "COMMENTS" column. The binding status was "DT_TEXT". The data flow column type is "DBBINDSTATUS_UNSUPPORTEDCONVERSION". The conversion from the OLE DB type of "DBTYPE_IUNKNOWN" to the destination column type of "DBTYPE_VARCHAR" might not be supported by this provider.

I have the above error when loading in a txt file. The COMMENTS field is VARCHAR(4000) the file is column pipe delimited with a text qualifier of "".

I'm stumped as cannot seem to find anything wrong with the data in the file itself, could this be a character somewhere that's not recognised??

Answer 1

I had the same issue. It went away after I changed the field size from VARCHAR(4000) to VARCHAR(max). Of course, you have to use the data conversion tool to change data type to text-stream(DT_TEXT).

Answer 2

Changing the target column in the database via SSMS to nvarchar(max) then re-running the data flow worked for me.