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