SQLTeam.com | Weblogs | Forums

Ssis package error


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.



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.


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


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 https://msdn.microsoft.com/en-us/library/hh313202(v=sql.110).aspx