Hi,
I got problem when i am sending the data from source to destination.
My source is Sql Server 2005 and My Destination is Sql Server 2005.
In Source table the column name is defined as numeric datatype.
In Destination table the column name is defined as UniqueIdentifier.
When i send the data from Source to Destination i am getting this error.
[Data Conversion 1 [4190]] Error: Data conversion failed while converting column "Req_seq1" (3959) to column "Copy of Req_seq1" (4204). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
UniqueIdentifier error in SSIS
Lee Nelson
Amit could you log this on the following site:
https://connect.microsoft.com/SQLServer
Make sure to provide a clear repro.
Thanks.
supersonic_oasis
In addition, you could try setting the error output of the data Conversion to redirect rows on error. You can then dump these to a text file to see what ones have failed, or just use a Data Viewer in the designer to quickly see what is failing.
tweston
The problem isn't in the destination. Its in the Data Conversion component. What data-type are you converting from and to
-Jamie
Ian Barber
Is your uniqueidentifier in text file in lower case, if yes then it looks like it is a bug in SSIS. I am having the same problem if the uniqueidentifier is in lower case in the csv file.