November 4, 2007 at 11:46 pm
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
November 6, 2007 at 2:02 am
Hallo there rookie...
After the you have done your calculations or whatever transformation you have done, try converting again so that your data type will match with one in the destination columns. Also you can change the one in destination columns to match the one that is coming in. Or try using Import task on SQL Server management studio so that you extract straight from the source to your tables.
I am new as well but hey!!! There are many ways to skin the cat.... Hope
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply