I have encountered inconsistencies using the excel data source. When I try to transform some of the fields in excel, though it has values, it sometimes returns null. For example, I have this column below:
X
--
50
30
20
70
60
Sometimes it works, meaning I can get all the values, sometimes I cant, which means it returns all null. Anybody encountered this issue before?
By the way, it only happens if there is some empty values within the working cell.
Thanks.
Cheers,
Ryan Tan
Your column contains what the driver has deemed to be a mix of numeric and text values. It has ruled in favor of the majority (numeric?) and returns other cell values as null. This is an age-old issue with the Excel driver. Please see the BOL topic on the Excel Source for workarounds for common issues.
I can email you a more detailed known issues document (than I was able to include in BOL) tomorrow if you'll remind me, please, at douglasl@.microsoft.com.
-Doug
|||Have a look at the article below. This explains the age-old issue with Excel.
http://www.sqldts.com/default.aspx?254
Thanks
Sutha
No comments:
Post a Comment