SQLTeam.com | Weblogs | Forums

Ssis package error


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