Home Forums Data Warehousing Integration Services no. of columns in excel may vary RE: no. of columns in excel may vary

  • June 20, 2014 at 11:46 pm

    #1723746

    ykonline (6/20/2014)

    Hi,

    I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary.

    Suppose, the 1st time we receive excel file may contain 10 columns the second time it may contains 12 columns etc.,

    Thanks in advance.

    The simplest is to always import the maximum number of columns and ignore the null columns in the stage area. Other options are i.e. programmatically building the import, one package for each document type triggered from a master package which detects the type etc..

    😎