UniqueIdentifier error in SSIS

Satish D

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.".

Jamie Thomson

The problem isn't in the destination. Its in the Data Conversion component. What data-type are you converting from and to

-Jamie

DarrenSQLIS

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.

amit lohia

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.

Bob Bojanic - MSFT

Amit could you log this on the following site:

https://connect.microsoft.com/SQLServer

Make sure to provide a clear repro.

Thanks.