Ssis package error

SSIS and Import/Export
1

while importing data from oracle into sql table i am getting error like 'The value could not be converted because of a potential loss of data'.

the sqltable field datatype is numberic(18,2) and the incoming values are like -21082160.03

Please help me to resolve it.

Thanks
subha

2

You've got some data that is not like that example. Find that data and correct it, then do the import. Or increase the numeric size.

3

You might get this is the incoming value is an empty string or all blanks, but not null. Sometimes I add a derived column:

! ISNULL(InputCol) ? InputCol : NULL(DT_WSTR(255))

and use the derived column downstream instead of the original one

4

You should use Lookup to join the common column( same data type) of SQL server and Oracle and retrieve the values from Oracle which does not have a matching record in SQL server.
You should go this one here you may find the help Migrating Oracle Data into SQL Server (OracleToSQL) - SQL Server | Microsoft Learn