SSIS: Import Data error

Question

SSIS: Import Data error

asukitta

Valued Member

Points: 67
More actions
March 15, 2010 at 6:55 am

#139494

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,

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dan.Humphries SSChampion Points: 12125 More actions · Answer 1

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.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

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?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

jasonmorris SSCrazy Points: 2492 More actions · Answer 4

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.