I have a SSIS package extraction data from flat file and putting into SQL SERVER database.
Extraction is happening successfully but i am getting errors as given below while loading the data:
[Sample Data destination [2162]] Error: There was an error with input column "OHomePhone" (597) on input "OLE DB Destination Input" (2175). The column status returned was: "The value could not be converted because of a potential loss of data.".
I am using a data conversion component to convert the erroring out fields into unicode string [DT_WSTR] and my destination data type in the column is int.
How to resolve this issue?
Please help