July 25, 2002 at 9:00 am
Hi all,
I am trying to execute a simple package with an excel spreadsheet being the source. one column during the transformation has 'NULL' inserted instead of the value. It is happening for about 20% of the rows. Some clues I have been able to uncover are.
1. The values that are transforming to null have letters in them where the ones that are transferring properly are all numbers. (I have experimented with all sorts of data types for the table and even re-formatted the spreadsheet datatype for the column to no avail.)
2. This probaly means something - when I look at the spreadsheet all the numbers that are transforming properly are right aligned in the cell. The cells that hold alphanumeric values (the ones that are producing the nulls) are all left aligned.
If anyone has any ideas I would be really appreciative.
Thanks, Scott
July 25, 2002 at 3:19 pm
Hi
Excel automatically aligns number values (or values it perceives to be numerical) to the right. All values perceived to be text (such as your alphanumeric values) are automatically left aligned by Excel. In the table you are importing the data into, the column in question should probably be a varchar data type of a large enough size (number of characters) to hold the longest value in the spreadsheet column in question.
hth,
Michael
Michael Weiss
Michael Weiss
July 25, 2002 at 4:47 pm
Agree. Or you could do a transform and try to convert the text to a meaningful number or just convert it to 0. Or get the formatting straightened out in Excel!
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply