17.00 - "The source column ""%s"" may contain some 8-byte unsigned integer values that cannot be represented as 18-digit signed decimal integers!" - Teradata Tools and Utilities

Teradata OLE DB Access Module Messages

prodname
Access Module
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1096-OLEDB

"The source column ""%s"" may contain some 8-byte unsigned integer values that cannot be represented as 18-digit signed decimal integers!"

Explanation:

This warning message comes while copying from OLE DB source to Teradata database and if BIG INT feature is not enabled.

Remedy:

Enable BIG INT feature using OleLoad tool. After reconnecting desired source/destination press YES button when asked for BIG INT or LARGE DECIMAL.