WinUtilis
__
SQL Server 2008 Data Types
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SQLServer2008DataTypes](
[bigint] [bigint] NULL,
[binary(50)] [binary](50) NULL,
[bit] [bit] NULL,
[char(10)] [char](10) NULL,
[date] [date] NULL,
[datetime] [datetime] NULL,
[datetime2(7)] [datetime2](7) NULL,
[datetimeoffset(7)] [datetimeoffset](7) NULL,
[decimal(18, 0)] [decimal](18, 0) NULL,
[float] [float] NULL,
[geography] [geography] NULL,
[geometry] [geometry] NULL,
[hierarchyid] [hierarchyid] NULL,
[image] [image] NULL,
[int] [int] NULL,
[money] [money] NULL,
[nchar(10)] [nchar](10) NULL,
[ntext] [ntext] NULL,
[numeric(18, 0)] [numeric](18, 0) NULL,
[nvarchar(50)] [nvarchar](50) NULL,
[nvarchar(MAX)] [nvarchar](max) NULL,
[real] [real] NULL,
[smalldatetime] [smalldatetime] NULL,
[smallint] [smallint] NULL,
[smallmoney] [smallmoney] NULL,
[sql_variant] [sql_variant] NULL,
[text] [text] NULL,
[time(7)] [time](7) NULL,
[timestamp] [timestamp] NULL,
[tinyint] [tinyint] NULL,
[uniqueidentifier] [uniqueidentifier] NULL,
[varbinary(50)] [varbinary](50) NULL,
[varbinary(MAX)] [varbinary](max) NULL,
[varchar(50)] [varchar](50) NULL,
[varchar(MAX)] [varchar](max) NULL,
[xml] [xml] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
| Sql Server Data Types |
|
SSIS Data Types |
| bigint |
= |
eight-byte signed integer [DT_I8] |
| binary |
= |
byte stream [DT_BYTES] |
| bit |
= |
Boolean [DT_BOOL] |
| date |
= |
single-byte unsigned integer [DT_UI1] |
| datetime |
= |
database timestamp [DT_DBTIMESTAMP] |
| decimal |
= |
numeric [DT_NUMERIC] |
| float |
= |
float [DT_R4] |
| int |
= |
four-byte signed integer [DT_I4] |
| image |
= |
image [DT_IMAGE] |
| nvarchar |
= |
Unicode string [DT_WSTR] |
| nchar |
= |
Unicode string [DT_WSTR] |
| ntext |
= |
Unicode text stream [DT_NTEXT] |
| numeric |
= |
numeric [DT_NUMERIC] |
| smallint |
= |
two-byte signed integer [DT_I2] / two-byte unsigned integer [DT_UI2] |
| text |
= |
text stream [DT_TEXT] |
| timestamp |
= |
byte stream [DT_BYTES] |
| tinyint |
= |
single-byte unsigned integer [DT_UI1] / single-byte signed integer [DT_I1] |
| uniqueidentifier |
= |
unique identifier [DT_GUID] |
| varbinary |
= |
byte stream [DT_BYTES] |
| varchar |
= |
string [DT_STR] |
| char |
= |
string [DT_STR] |
| xml |
= |
Unicode string [DT_WSTR] |
|