Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Working with Data Types in the Data Flow

 

When developing a custom data flow component in Integration Services, you work constantly with data types, copying data into and out of data flow buffers and transforming values. The information in this topic helps you to choose the correct Integration Services data types, and to use the correct methods when working with them.

The T:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer class provides a series of Set methods for copying data into buffer columns, and a corresponding series of Get methods for retrieving data from buffer columns. The following tables show you which method to use with each Integration Services data type.

The following table lists the data type in the first column, and then lists the corresponding Set and Get methods.

Data Type

Set Method

Get Method

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BOOL

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetBoolean(System.Int32,System.Boolean)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetBoolean(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BYTES

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetBytes(System.Int32,System.Byte[])

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetBytes(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_CY

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDecimal(System.Int32,System.Decimal)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDecimal(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DATE

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTime(System.Int32,System.DateTime)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDateTime(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBDATE

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDate(System.Int32,System.DateTime)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDate(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetTime(System.Int32,System.TimeSpan)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetTime(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetTime(System.Int32,System.TimeSpan)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetTime(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTime(System.Int32,System.DateTime)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDateTime(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTime(System.Int32,System.DateTime)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDateTime(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMPOFFSET

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTimeOffset(System.Int32,System.DateTimeOffset)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDateTimeOffset(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DECIMAL

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDecimal(System.Int32,System.Decimal)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDecimal(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_FILETIME

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTime(System.Int32,System.DateTime)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDateTime(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_GUID

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetGuid(System.Int32,System.Guid)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetGuid(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I1

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetSByte(System.Int32,System.SByte)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetSByte(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetInt16(System.Int32,System.Int16)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetInt16(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I4

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetInt32(System.Int32,System.Int32)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetInt32(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I8

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetInt64(System.Int32,System.Int64)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetInt64(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_IMAGE

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[]) or M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[],System.Int32)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetBlobData(System.Int32,System.Int32,System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NTEXT

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[]) or M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[],System.Int32)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetBlobData(System.Int32,System.Int32,System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NULL

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetNull(System.Int32)

There is no Get method that is applicable to this data type.

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NUMERIC

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDecimal(System.Int32,System.Decimal)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDecimal(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_R4

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetSingle(System.Int32,System.Single)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetSingle(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_R8

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDouble(System.Int32,System.Double)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetDouble(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_STR

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(System.Int32,System.String)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetString(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_TEXT

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[]) or M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[],System.Int32)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetBlobData(System.Int32,System.Int32,System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI1

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetByte(System.Int32,System.Byte)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetByte(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetUInt16(System.Int32,System.UInt16)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetUInt16(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI4

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetUInt32(System.Int32,System.UInt32)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetUInt32(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI8

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetUInt64(System.Int32,System.UInt64)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetUInt64(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(System.Int32,System.String)

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.GetString(System.Int32)

Set Method

Data Type

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[]) or M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddBlobData(System.Int32,System.Byte[],System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_IMAGE, F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NTEXT, or F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_TEXT

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetBoolean(System.Int32,System.Boolean)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BOOL

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetByte(System.Int32,System.Byte)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI1

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetBytes(System.Int32,System.Byte[])

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BYTES

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDate(System.Int32,System.DateTime)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBDATE

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTime(System.Int32,System.DateTime)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DATE, F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP, F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP2, or F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_FILETIME

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDateTimeOffset(System.Int32,System.DateTimeOffset)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMPOFFSET

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDecimal(System.Int32,System.Decimal)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_CY, F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DECIMAL, or F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NUMERIC

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetDouble(System.Int32,System.Double)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_R8

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetGuid(System.Int32,System.Guid)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_GUID

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetInt16(System.Int32,System.Int16)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetInt32(System.Int32,System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I4

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetInt64(System.Int32,System.Int64)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I8

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetNull(System.Int32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NULL

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetSByte(System.Int32,System.SByte)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I1

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetSingle(System.Int32,System.Single)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_R4

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(System.Int32,System.String)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_STR or F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetTime(System.Int32,System.TimeSpan)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME or F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetUInt16(System.Int32,System.UInt16)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI2

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetUInt32(System.Int32,System.UInt32)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI4

M:Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetUInt64(System.Int32,System.UInt64)

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI8

While moving data from sources through transformations to destinations, a data flow component must sometimes convert data types between the SQL Server Integration Services types defined in the T:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType enumeration and the managed data types of the Microsoft .NET Framework defined in the System namespace. In addition, a component must sometimes convert one Integration Services data type to another before that type can be converted to a managed type.

System_CAPS_noteNote

The mapping files in XML format that are installed by default to C:\Program Files\Microsoft SQL Server\120\DTS\MappingFiles are not related to the data type mapping discussed in this topic. These files map data types from one database version or system to another (for example, from SQL Server to Oracle), and are used only by the SQL Server Import and Export Wizard. For more information on these mapping files, see SQL Server Import and Export Wizard.

The M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.BufferTypeToDataRecordType(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType) and the M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.DataRecordTypeToBufferType(System.Type) methods map Integration Services data types to managed data types.

System_CAPS_cautionCaution

Developers should use these methods of the T:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class with caution, and may want to code data type mapping methods of their own that are more suited to the unique needs of their custom components. The existing methods do not consider numeric precision or scale, or other properties closely related to the data type itself. Microsoft may modify or remove these methods, or modify the mappings that they perform, in a future version of Integration Services.

The following table lists how the M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.BufferTypeToDataRecordType(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType) and the M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.DataRecordTypeToBufferType(System.Type) methods map various Integration Services data types to managed data types.

Integration Services Data Type

Maps to this Managed Data Type

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR

System.String

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BYTES

Array of System.Byte

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP

System.DateTime

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP2

System.DateTime

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMPOFFSET

System.DateTimeOffset

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBDATE

System.DateTime

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME

System.TimeSpan

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME2

System.TimeSpan

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DATE

System.DateTime

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_FILETIME

System.DateTime

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NUMERIC

System.Decimal

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_GUID

System.Guid

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I1

System.SByte

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I2

System.Int16

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I4

System.Int32

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I8

System.Int64

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BOOL

System.Boolean

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_R4

System.Single

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_R8

System.Double

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI1

System.Byte

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI2

System.UInt16

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI4

System.UInt32

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_UI8

System.UInt64

Sometimes a data flow component must also convert one Integration Services data type to another before that type can be converted to a managed type. The M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.ConvertBufferDataTypeToFitManaged(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType,System.Boolean@) method class maps Integration Services data types to other Integration Services data types that can then be mapped to managed data types by using the M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.BufferTypeToDataRecordType(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType) method.

System_CAPS_cautionCaution

Developers should use these methods of the T:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent class with caution, and may want to code data type mapping methods of their own that are more suited to the unique needs of their custom components. The existing methods do not consider numeric precision or scale, or other properties closely related to the data type itself. Microsoft may modify or remove these methods, or modify the mappings that they perform, in a future version of Integration Services.

The following table lists how the M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.ConvertBufferDataTypeToFitManaged(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType,System.Boolean@) method maps Integration Services data types to other Integration Services data types.

Original Integration Services Data Type

Maps to this Integration Services Data Type

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DECIMAL

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NUMERIC

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_CY

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NUMERIC

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DATE

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBDATE

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_FILETIME

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP2

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIMESTAMP

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_DBTIME2

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BOOL

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_I4

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_TEXT

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_NTEXT

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_STR

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_IMAGE

F:Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_BYTES

System_CAPS_noteNote

The M:Microsoft.SqlServer.Dts.Pipeline.PipelineComponent.ConvertBufferDataTypeToFitManaged(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType,System.Boolean@) method does not return a value for the DT_DBTIMESTAMPOFFSET data type, and a T:Microsoft.SqlServer.Dts.Pipeline.UnsupportedBufferDataTypeException occurs. You must convert the DT_DBTIMESTAMPOFFSET data type to one of the Integration Services date/time data types that can be mapped to a managed data type. For a list of Integration Services date/time data types that can be mapped to a managed data types, see the table in the previous section, "Mapping between Integration Services and Managed Data Types." For information about converting data types, see Integration Services Data Types.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Show:
© 2015 Microsoft