I am using SQL 2005 SSIS. I have created a package that imports and exports
data and have captured an error log for any bad import records. What i want
to do at the end of the package is email that status with the following
criteria:
1) No import errors and import successful
2) Import errors exist (attaching a error log) and some records successfully
imported.
3) No import done

I have created 2 variables (error and import) to capture the number of
records in each. Can I use both in the same constraint expression so that
for option 1 above it would be "@error == 0 and @import > 0", option 2 would
be "@error > 0 and @import > 0" and option 3 would be "@import ==0"? What is
the correct syntax to use "and" in the constraint expression?