SQLTeam.com | Weblogs | Forums

SSIS package execution flow


#1

Hi,

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.


#2

can you post the error messages or messages from the execution process?
do you have a precedence connector from your email task to step 3? Any conditions or expressions on it?