Designer Guide

10.4.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

Port-to-Port Data Conversion

The Integration Service converts data based on the datatype of the port. Each time data passes through a port, the Integration Service looks at the datatype assigned to the port and converts the data if necessary.

When you pass data between ports of the same numeric datatype and the data is transferred between transformations, the Integration Service does not convert the data to the scale and precision of the port that the data is passed to. For example, you transfer data between two transformations in a mapping. If you pass data from a decimal port with a precision of 5 to a decimal port with a precision of 4, the Integration Service stores the value internally and does not truncate the data.

You can convert data by passing data between ports with different datatypes. For example, you can convert a string to a number by passing it to an Integer port.

The Integration Service performs port-to-port conversions between transformations and between the last transformation in a dataflow and a target.

The following table describes the port-to-port conversions the Integration Service performs:

Datatype	Bigint	Integer, Small Integer	Decimal	Double, Real	String, Text	Nstring, Ntext	Date/Time	Binary
Bigint	No	Yes	Yes	Yes	Yes	Yes	No	No
Integer, Small Integer	Yes	No	Yes	Yes	Yes	Yes	No	No
Decimal	Yes	Yes	No	Yes	Yes	Yes	No	No
Double, Real	Yes	Yes	Yes	No	Yes	Yes	No	No
String, Text	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Nstring, Ntext	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No
Date/Time	No	No	No	No	Yes	Yes	Yes	No
Binary	No	No	No	No	No	No	No	Yes

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Port-to-Port Data Conversion

Port-to-Port Data Conversion