How to know if a column is missing in my excel file when using Excel Source Plus component?

How to know if a column is missing in my excel file when using Excel Source Plus component?

If a column is missing in your excel file when using the Excel Source Plus component, your SSIS+ package will execute successfully, but we generate a warning message in the package event log. Please look at the screenshot below: 


    Book a Presales Call

     

    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now.