I am new to error handling in SSIS. What should I use package level, task level error handling....?
I want to capture following information while loading data from CSV to sql table:
1. SSIS package start time
2. Data validation like input data is not in correct formart or duplicate
3. Database SQL (insert operation) error
4. SSIS package End Time
Can anyone please suggest how to proceed on this.
View Complete Post