March 15, 2010 at 6:55 am
Data conversion failed. The data conversion for column "MR_E" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
The "output column "MR_E" (12)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "MR_E" (12)" specifies failure on error. An error occurred on the specified object of the specified component.
the row is:
649211;A;00.07.21;,05;PO
The column with the problem is ,05 and this is decimal, I changed to Double but the problem persists,
March 15, 2010 at 7:14 am
If you could provide some more information that would be helpful. Is this in a package? What are you loding froma and what transform or destination is giving the error?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 15, 2010 at 7:53 am
Check the Regional Settings on the computer running the package and ensure that 'Decimal Symbol' is set to comma, rather than a full-stop.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 18, 2010 at 2:42 pm
asukitta (3/15/2010)
Data conversion failed. The data conversion for column "MR_E" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".The "output column "MR_E" (12)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "MR_E" (12)" specifies failure on error. An error occurred on the specified object of the specified component.
the row is:
649211;A;00.07.21;,05;PO
The column with the problem is ,05 and this is decimal, I changed to Double but the problem persists,
Assuming the column separator is semicolon (;) then your value is in fact: ,05[/color]
Do you manipulate the column before trying to convert to decimal?
March 25, 2010 at 9:54 am
Had this earier today and it turned out my column delimiter was inside a column (was using tab). Changed the delimiter and all was well. Message is a bit spurious in my opinion.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply