I created a package - to create few tables and export data to flat file.
step 1 - exec Stored procedures
Step2 - export customer table data to flat file
step3 - export product table data to flat file
this worked perfect.
Now I wanted to add error handling. If customer export success/failed send email and then go to step3. Same with product export needs to send email when failed/success. I tested email task it is working correctly.
after adding the email tasks, package is not working.
it just get stopped, after sending success or failed email for customer file. the product export is not getting executed.
not sure what I am missing.
thanks for any suggestion.