Mar 31, 2014

The external column "" of "component "ADO NET Destination" has a data type that cannot be mapped to a Data Flow task data type. The Data Flow task data type DT_NTEXT will be used instead.


In SSIS when we will create task where data destination is ADO NET Destination. Suppose it loads data into the table tblTarget:


CREATE TABLE tblTarget (

    ID INT,

    Remarks SQL_VARIANT

)


We will get error message like:

The external column "Remarks" of "component "ADO NET Destination" has a data type that cannot be mapped to a Data Flow task data type. The Data Flow task data type DT_NTEXT will be used instead.

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 of Remarks column like VARCHAR(MAX), NVARCHAR(MAX) etc.

No comments:

Post a Comment