Hi gurus, I have two date columns in the report and they are date format. My requirement is user downloadds the report and puts date values in those two fields and save into file share. I have to loop through those files and load those changes to a table. But while reading from excel source Datecol1 is reading fine but Datecol2 is showing as NULLs even though there are some dates in that column. I am using excel source and queryying the source to get data from required sheet as: SELECT * FROM sheet3$[A3:D50] How can I retrieve my data column? Please help me with this.

Check your excel source if it has valid date data for DateCol2. If it has worked for DateCol1 there is no reason for it not read DateCol2 incorrectly unless the source data is invalid.http://btsbee.wordpress.com/

Check your excel source if it has valid date data for DateCol2. If it has worked for DateCol1 there is no reason for it not read DateCol2 incorrectly unless the source data is invalid. http://btsbee.wordpress.com/ Actually I think the problem was for first 10-15 rows the value in the Datecol2 is NULL. so, SSIS is reading them as NULL for the whole column. the resolution for this is to add IMEX=1 to the excel connection manager proprerty. That solved the issue.