Post reply

Data Flow - Excel - Variable Headings

  • November 4, 2011 at 1:03 am

    #390764

    Hi everyone

    I have a SSIS packages that uses data that has been imported from an Excel file.

    At the moment the import process is manual, using the Import/Export Wizard.

    The reason being, the Excel file can contain different headings.

    The headings are standard, about 30 in total, but not all of them are present in every file.

    Is there a way to create the mapping for a "full" heading set and making it ignore when certain columns are not present?

    Thanks in advance.

  • November 4, 2011 at 2:03 am

    #1403091

    Not with SSIS out-of-the-box.

    SSIS will fix the metadata, so it can read the file faster. If the metadata changes, SSIS will crash.

    CozyRoc has a commercial component that can handle this type of situation.

    A workaround is to read the entire file as one column, than split the column yourself in the columns you need.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 4, 2011 at 2:17 am

    #1403097

    Thanks Koen, that was going to be my next work around if this doesn't work.

    I guess I will create a script that checks for each column and imports the data.

    Thanks for the input.

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

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