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

  • June 21, 2014 at 3:57 pm

    #1723813

    Jeff Moden (6/21/2014)

    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.

    Does that also mean that the columns present in a 10 column spreadsheet could be in different positions for the 12 column spreadsheets?

    Missing here is the information on if and how one import relates to another. For what it's worth, those are, in my experience the first signs of a fully meta-data driven ETL requirements. And that is starting with a toothpick and ending up with a forest.

    😎