Mar 31, 2014

The data type "" found on column "" is not supported for the . This column will be converted to DT_NTEXT.


In SSIS when we will create task where data source is ADO NET Source or OLE DB source. Suppose it loads data from table tblSource:

CREATE TABLE tblSource(
    ID INT,
    Remarks SQL_VARIANT
)

We may get a warning message like:

The data type "System.Object" found on column "" is not supported for the component "ADO NET Source". This column will be converted to DT_NTEXT.


Cause: SSIS doesn't support a column of data type SQL_VARIANT. So SSIS package will type case data of Remarks column into the DT_NEXT.

Solution:

Since it is warning message so if you want to continue it then, click on OK button.

Or you can also change the data type Remarks column like VARCHAR(MAX), NVARCHAR(MAX) etc.

No comments:

Post a Comment