Hello everyone, long time no see!, I have a problem and was hoping someone can help me:
I'm using SSIS 2005 Enterprise edition,ÃÂ I'm creating a package that reads an excel (xls)ÃÂ file using the "excel source" component, and it dumps the data into an OLEDB destination (a sql server).
When I drag the excel source component andÃÂ create the excel connection to my file the component automatically reads the columns and their datatypes.
The problem is that I have a column which has numeric data and the package uploads as NULL every number that starts with a zero. (note: in excel this columnÃÂ is formatted as "text", despite it has only numbers, because it's the only way excel maintains the left sided zeros).
So I checked the data types by right clicking the excel source component -> show advanced editor and my surprise is that this column's data type is detected as double-precision float, and it doesn't let me change it.
I tried the answer posted here: http://devselekta.blogspot.com/2007/09/ssis-excel-data-source-values-returned.html
ÃÂ but it only works when the first row of data hasÃÂ a numberÃÂ beginning with zero on this column.
Someone knows how to get the data imported correctly? Thanks in advance.
View Complete Post