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.
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