Post reply

dynamically add the columns in excel using ssis

  • November 24, 2014 at 1:36 pm

    #301440

    Hi,

    I have given to create a ssis package where i have list of columns mapped from excel to sql destination using ssis. For some excel sheets some column headers will be missing. i want to check if the columnheader doesn't exists in the excel sheet i should add that column automatically so that the mappings in ssis works fine without any error.

    Anyone did this type of scenario? please help

  • November 26, 2014 at 8:48 am

    #1761123

    my starting point would be to look at a script task using C#. I have done similar with flat files but not to Excel. But you should be able to access the sheets in the Excel using C# and then look at the first row.

    googling 'c# read sheets from excel' came up with

    HTH

    E

    😀

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

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