Double precision float DT_R8 column error
-
Hi,
I have a double precision float column named Fax from an excel 20077 source and its of type DT_R8 but the value is 222-666-9999 . When I run the package I get the following error because of this field :
[OLE DB Source [53329]] Error: There was an error with output column "Fax" (53427) on output "OLE DB Source Output" (53339). The column status returned was: "The value could not be converted because of a potential loss of data."
There are other columns with DT_R8 datatype but those columns have values like :22222 etc that all numeric and no dashes in between.
How do I fix this issue ? Please help.
-
PSB (11/4/2010)
Hi,I have a double precision float column named Fax from an excel 20077 source and its of type DT_R8 but the value is 222-666-9999 . When I run the package I get the following error because of this field :
[OLE DB Source [53329]] Error: There was an error with output column "Fax" (53427) on output "OLE DB Source Output" (53339). The column status returned was: "The value could not be converted because of a potential loss of data."
There are other columns with DT_R8 datatype but those columns have values like :22222 etc that all numeric and no dashes in between.
How do I fix this issue ? Please help.
You should not use DT_R8 for this column, but DT_WSTR.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
I don't have any control over the source excel file. Is there any way I can convert it ?
-
PSB (11/5/2010)
I don't have any control over the source excel file. Is there any way I can convert it ?Can you try the following:
1. Right-click on the Excel Source component and select 'Advanced Editor...'
2. Go to 'Input and Output Properties' tab and expand Excel Source Output.
3. Try to change the type of the column in the 'Output Columns' .
Did it work ?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
No it did not.
-
PSB (11/8/2010)
No it did not.This is very terse description. Can you provide more details what's happened? Did you get an error or what?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
I get the following error :
An OlEDb error has occured . error code 0X80004005
An OLE DB record os available. Source Microsoft office access database engine" Description : Invalid argument.
The acquire connection method call to the connection manager EXCEL 2007 failed with the error code 0XC0202009
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply