March 5, 2013 at 1:01 pm
I have a csv file (FIXED Width) with one cloumn and I read that column as string data type and then covert to Numeric (10,0) using Data Conversion Task.
But I get this error when I run the pacakge:
The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
I tried to redirect the error Rows and found out that, when every the column has "0" as a value its redirecting it. I am not able to understand why is it, not able to read 0 as numeric(10,0). Where it is able to load other values except "0" ( I have seen even -1, -1234 doesnt have any problem)
I enabled "Retain null values from the source as null values in the data flow" on the Flat file Source editor.
Anyone out there had experienced this? SSIS is wired.....
March 6, 2013 at 12:41 am
quillis131 (3/5/2013)
I have a csv file (FIXED Width)
Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 6, 2013 at 12:46 am
weird forum error - this post was meant for a different thread - post removed
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 6, 2013 at 7:29 am
opc.three (3/6/2013)
quillis131 (3/5/2013)
I have a csv file (FIXED Width)Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?
What got my attention was that I initially read it as
".. a csv file (FIXED Width) with one clown ... "
🙂
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
March 6, 2013 at 7:52 am
Phil Parkin (3/6/2013)
opc.three (3/6/2013)
quillis131 (3/5/2013)
I have a csv file (FIXED Width)Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?
What got my attention was that I initially read it as
".. a csv file (FIXED Width) with one clown ... "
🙂
Its is CSV file with one Column as Fixed width
March 6, 2013 at 8:00 am
quillis131 (3/6/2013)
Phil Parkin (3/6/2013)
opc.three (3/6/2013)
quillis131 (3/5/2013)
I have a csv file (FIXED Width)Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?
What got my attention was that I initially read it as
".. a csv file (FIXED Width) with one clown ... "
🙂
Its is CSV file with one Column as Fixed width
No it isn't. It is either CSV or Fixed Width, not both.
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
March 6, 2013 at 9:54 am
Phil Parkin (3/6/2013)
quillis131 (3/6/2013)
Phil Parkin (3/6/2013)
opc.three (3/6/2013)
quillis131 (3/5/2013)
I have a csv file (FIXED Width)Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?
What got my attention was that I initially read it as
".. a csv file (FIXED Width) with one clown ... "
🙂
Its is CSV file with one Column as Fixed width
No it isn't. It is either CSV or Fixed Width, not both.
Its a Fixed Width File
March 6, 2013 at 12:22 pm
Chances are you have your Flat File Connection Manager setup incorrectly. When you go to Preview, does your data line up? If not, make sure you are accounting for the End Of Line characters in your column-definitions.
If you're stuck zip your SSIS Package and a few lines of your data file to this thread and I'll have a look.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply