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