SSIS: Data types mapping to SQL

SSIS : – Mapping Integration Services Data Types to Database Data Types
Data Type SQL Server (SqlClient) Jet Oracle (OracleClient) DB2 (DB2OLEDB)
DT_BOOL bit Bit
DT_BYTES binary, varbinary, timestamp BigBinary, VarBinary RAW
DT_CY smallmoney, money Currency
DT_DATE
DT_DBDATE
DT_DBTIME
DT_DBTIMESTAMP datetime, smalldatetime DateTime TIMESTAMP, DATE, INTERVAL TIME, TIMESTAMP, DATE
DT_DECIMAL
DT_FILETIME
DT_GUID uniqueidentifier GUID
DT_I1
DT_I2 smallint Short SMALLINT
DT_I4 int Long INTEGER
DT_I8 bigint BIGINT
DT_NUMERIC decimal, numeric Decimal NUMBER, INT DECIMAL, NUMERIC
DT_R4 real Single REAL
DT_R8 float Double FLOAT, REAL FLOAT, DOUBLE
DT_STR VarChar CHAR, VARCHAR
DT_UI1 tinyint Byte
DT_UI2
DT_UI4
DT_UI8
DT_WSTR char, varchar, nchar, nvarchar, sql_variant, xml LongText CHAR, ROWID, VARCHAR2, NVARCHAR2, NCHAR GRAPHIC, VARGRAPHIC
DT_IMAGE image LongBinary LONG RAW, BLOB, LOBLOCATOR, BFILE, VARGRAPHIC, LONG VARGRAPHIC, user-defined CHAR () FOR BIT DATA, VARCHAR () FOR BIT DATA
DT_NTEXT text, ntext LONG, CLOB, NCLOB, NVARCHAR, TEXT LONG VARCHAR, NCHAR, NVARCHAR, TEXT
DT_TEXT LONG VARCHAR FOR BIT DATA

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s