The SQL Server Integration Services Data Type Map

Data Type
SQL Server	SSIS	SSIS	OLE DB	ADO.NET
	Variables	Pipeline Buffer
bigint	Int64	DT_I8	LARGE_INTEGER	Int64
binary	Object	DT_BYTES	n/a	Binary
bit	Boolean	DT_BOOL	VARIANT_BOOL	Boolean
char	String	DT_STR	VARCHAR	StringFixedLength
date	Object	DT_DBDATE	DBDATE	Date
datetime	DateTime	DT_DBTIMESTAMP	DATE	DateTime
datetime2	Object	DT_DBTIMESTAMP2	DBTIME2	DateTime2
datetimeoffset	Object	DT_DBTIMESTAMPOFFSET	DBTIMESTAMPOFFSET	DateTimeOffset
decimal	Object	DT_NUMERIC	NUMERIC	Decimal
	(< SQL 2012)
	Decimal
	(>= SQL 2012)
float	Double	DT_R8	FLOAT	Double
image	Object	DT_IMAGE	n/a	Binary
int	Int32	DT_I4	LONG	Int32
money	Object	DT_CY	CURRENCY	Currency
		(OLE DB)
		DT_NUMERIC
		(ADO.NET)
nchar	String	DT_WSTR	NVARCHAR	StringFixedLength
ntext	String	DT_NTEXT	n/a	String
numeric	Object	DT_NUMERIC	NUMERIC	Decimal
	(< SQL 2012)
	Decimal
	(>= SQL 2012)
nvarchar	String	DT_WSTR	NVARCHAR	String
nvarchar(max)	Object	DT_NTEXT	n/a	n/a
real	Single	DT_R4	FLOAT, DOUBLE	Single
rowversion	Object	DT_BYTES	n/a	Binary
smalldatetime	DateTime	DT_DBTIMESTAMP	DATE	DateTime
smallint	Int16	DT_I2	SHORT	Int16
smallmoney	Object	DT_CY	CURRENCY	Currency
		(OLE DB)
		DT_NUMERIC
		(ADO.NET)
sql_variant	Object	DT_WSTR		Object
		(OLE DB)
		DT_NTEXT
		(ADO.NET)
table	Object	n/a
text	Object	DT_TEXT	n/a	n/a
time	Object	DT_DBTIME2	DBTIME2	Time
timestamp	Object	DT_BYTES	n/a	Binary
tinyint	Byte	DT_UI1	BYTE	Byte
uniqueidentifier	String	DT_GUID	GUID	Guid
	(OLE DB)
	Object
	(ADO.NET)
varbinary	Object	DT_BYTES	n/a	Binary
varbinary(max)	Object	DT_IMAGE	n/a	Binary
varchar	String	DT_STR	VARCHAR	String
varchar(max)	Object	DT_TEXT	n/a	n/a
xml	Object	DT_NTEXT