ykonline (6/7/2014)Hi,I have a requirement to import excel sheet which we receive daily, sometimes it may contain extra columns that needs to be imported to staging table as it is.

Please do the needful...

Simplest way is to always import the maximum number of column ever needed and then ignore those which are completely empty in the staging area. That is easily handled in SQL and requires trickery in SSIS.