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