how to import excel sheet with varying no. of columns in ssis

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

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

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply