detect an empty flat file source ssis
Hi..
I have to load an excel file into temp table,But if the file contains 0 records then i should get a notification and package should be stopped.
How is this possible in SSIS?
How to do the Logging In ssis and send notifications?
Please help me.
Thanks
June 9th, 2011 11:55pm
Hi Will,
your suggestion looks good however i don`t want to load the file into any destinantion with out checking the row count.
According to your suggestion i have to load the excel file into a database table first and take row count from that .
Is there any way we can write a script task to check the row count directly from excel file or do i need to write any macro with in excel to calculate the row count.
Thanks
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 2:10am
Thank you very much for all your inputs.
June 10th, 2011 3:47pm