I am trying to extract the data out of an excel file with 3 columns Success, Failure and Waiting. The data from Success and Failure is getting extracted perfectly, but no data is being extracted from the excel file. The data types of source and destination are matching. I tried different file with the same structure..but still no data is being extracted from the Waiting column.
What method are you using? SSIS or something else? What is the data in the Excel sheet like? If it is a numeric and non-numeric data, you could try setting IMEX=1 (intermixed).
I am not using I/E wizard mate..its just excel source and oledb destination..I have made sure that the datatypes and mapping are correct but the data viewer,after the source, is not showing data for this column but showing data for other columns properly
Only one column not extracting from Excel source
Posted - 03/17/2013 : 16:42:59
