Sample Header Ad - 728x90

Validate Excel File data source in SSIS package

0 votes
0 answers
411 views
I need to load a number of Excel files using SSIS package into a SQL Server table. I am able to successfully loop through and load my Excel files into my table I do not have any issue doing that, BUT as part of the task, I need to (validate)make sure, the files have a consistent format for all of received Excel files, things I need to check are: + Number of columns should be the same. + Data type for each column should be the same. + Certain columns should not have null/empty values. What do you suggest as the best way (simplicity and performance) to do this? Is using Script task / C# a good way? (the question is only about validating the Excel file format and columns data type)
Asked by Alex ghulami (1 rep)
Aug 8, 2023, 11:43 PM