CODEWITHSUNDEEP
sql-serverssisintteradatabigint
K.Dharma
K.Dharma

Reputation: 39

BIGINT to INT conversion in Terada

I'm trying to load BIGINT column (A) data from teradata to INT column(A) in sql server using SSIS package.

I tried data conversion, it didn't work. Thought of limiting data to INT in teradata side. I got the following error:

numeric overflow occurred during computation error.

Also, I tried to recreate SQL server table column with bigint datatype, it didn't work as getting error while running Processing engine as it's configured int datatype for that column. please let me know if there is any way i can use to solve this issue? Thank you!

Upvotes: 2

Views: 617

Answers (1)

Hadi
Hadi

Reputation: 37348

I think that the recreating the SQL destination table with BIGINT data type should work. But you have to make sure that the metadata is updated in the SSIS package.

Upvotes: 1

Related Questions