Wednesday, 13 November 2013

SQL Server Data Types Vs SSIS Data Types

SQL Server Data Types Vs SSIS Data Types
SQL Server Data Type
SSIS Data Type
SSIS Expression
Smallint
Single-Byte Signed Integer
(DT_I1)
Two-Byte Signed Integer
(DT_I2)
Int
Four-Byte Signed Integer
(DT_I4)
Bigint
Eight-Byte Signed Integer
(DT_I8)
Tinyint
Single-Byte Unsigned Integer
(DT_UI1)
Two-Byte Unsigned Integer
(DT_UI2)
Four-Byte Unsigned Integer
(DT_UI4)
Eight-Byte Unsigned Integer
(DT_UI8)
Real
Float
(DT_R4)
Float
Double-Precision Float
(DT_R8)
Char, Varchar
String
(DT_STR, «length», «code_page»)
Nchar, Nvarchar, Sql_Variant, Xml
Unicode Text Stream
(DT_WSTR, «length»)
Date
Date
(DT_DATE)
Bit
Boolean
(DT_BOOL)
Decimal, Numeric
Numeric
(DT_NUMERIC, «precision», «scale»)
Decimal
Decimal
(DT_DECIMAL, «scale»)
Smallmoney, Money
Currency
(DT_CY)
Uniqueidentifier
Unique Identifier
(DT_GUID)
Binary, Varbinary, Timestamp
Byte Stream
(DT_BYTES, «length»)
Date
Database Date
(DT_DBDATE)
Database Time
(DT_DBTIME)
Time(P)
Database Time With Precision
(DT_DBTIME2, «scale»)
Datetime, Smalldatetime
Database Timestamp
(DT_DBTIMESTAMP)
Datetime2
Database Timestamp With Precision
(DT_DBTIMESTAMP2, «scale»)
Datetimeoffset(P)
Database Timestamp With Timezone
(DT_DBTIMESTAMPOFFSET, «scale»)
File Timestamp
(DT_FILETIME)
Image
Image
(DT_IMAGE)
Text
Text Stream
(DT_TEXT, «code_page»)
Ntext
Unicode String
(DT_NTEXT)

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts