This topic has not yet been rated - Rate this topic

DTS_E_CANTINSERTCOLUMNTYPE

SQL Server 2008

SQL Server 2008 R2

Product Name	SQL Server
Product Version	10.0
Product Build Number
Event ID	-1071636235
Event Source	dtsmsg.rll
Component	Integration Services
Symbolic Name	DTS_E_CANTINSERTCOLUMNTYPE
Message Text	The column "__" can't be inserted because the conversion between types __ and __ is not supported.

Explanation

The column cannot be added to the database table because the conversion between the Integration Services column data type and the database column data type is not supported.

The hexadecimal value for this error number is 0xC02020FS.

Possible Causes

The conversion between the specified data types is not supported.

User Action

Explicitly convert the column to a data type that can be converted to the database column data type, and then add the column to the database table.

Concepts

Integration Services Data Types

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD