DSXchange

Posted: **Fri Jan 07, 2011 11:34 pm**

Hi,

Can anyone help with the warning raised in Surrogate Key Generator. The warning is 'Implicit conversion from source type "uint64" to result type "int64": Possible range limitation.' . This happens for all of our jobs using this stage.
We want the message handler to be our last option.

Sequence Source type within SK stage is Oracle database.

Regards,

Novak

Posted: **Sat Jan 08, 2011 12:48 am**

Define the attribute as Unsigned integer at Target. You can define the Unsigned integer at extended option of columns tab.

Posted: **Sun Jan 09, 2011 5:45 pm**

Hi,

There is no such thing as 'extended option' under output tab in Surrogate Key stage.

Regards,

Novak

Posted: **Sun Jan 09, 2011 9:51 pm**

It is located in the Columns grid of the Output link of the stage.

Output->Columns->Extended column

Alternately, you can double-click on the column number (to the left of the column name) to open the properties for that column. There is an Extended (unsigned) checkbox on the left of the window.

Regards,

Posted: **Sun Jan 09, 2011 10:41 pm**

Thanks a lot Ravi and James.
Issue fixed.

Regards,

Novak

DSXchange

Warning for Implicit conversion "uint64" to "

Warning for Implicit conversion "uint64" to "