i am very new to SSIS. and i was wondering if anyone could help me with this.
I have an SSIS Package that insert excel files to the MS SQL Database. Inside the foreach loop, i have a Data Flow Task which manages the inserting of excel. What i want is before i upload my excel file, (before going through the data flow task) i want to validate the excel file if its has any empty cell. If yes, it will proceed to the data flow. if not, it must notify the user via email and/or move the excel file in some other folder. This validation i want to do inside a Script Task. I am using C#.