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]
 
© 2006 Javier Hernandez. All rights reserved. Terms of Use