I exported some data using sqlplus in Windows server to a csv file.
I'm trying to import the csv file into sql server using SSIS but get this error:
[OLE DB Destination [1743]] Error: An error occurred while setting up
a binding for the "TECHNOLOGY" 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.
The destination table was created using the ddl from the oracle table and in my data flow task in SSIS the varchar columns are DT_TEXT datatype. In the dest table, they are varchar(10) and in oracle, they were also varchar(10)
I tried using derived column with this expression: (DT_STR,12,1252)[Column 1]
but get this error then:
[OLE DB Destination [1770]] Error: An error occurred while setting up a binding for the "TECHNOLOGY" 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.
any ideas on this?