Your current expression will not do that. In that case, you'd want your expression to evaluate to True when error count > zero and error count 0 ||...

With that expression, you will send an e-mail every time your Error Count is greater than or equal to your Max Count. If you want to get an e-mail...

Well, what did you have to do? Was it the expression?

So your error count variable is zero. Based on your expression, the email will be sent. Your expression is errorcount = maxcount?

Well, we need to determine if your error count variable contains the value you expect it to. I'm guessing that it does not because your expression looks OK and...

Have you set a breakpoint on your mail task and looked at the run time value of your errorcount variable? Where is the variable getting populated?

Yep, that's what I'm talking about. So it does not work for you.

What does your expression inside your precedence constraint look like?

I assume this is the package from your other thread?

http://www.sqlservercentral.com/Forums/Topic761855-148-11.aspx#bm772890

You can accomplish this by setting the precedence constraint between your data flow task and the e-mail task to use an...

Rowan,

A couple of things. First, I like you name! Secondly, all of the advice given here is spot on. One thing I'd like to mention in...

OK. If syncronizing is one-way only. Why can't you use log shipping or replication?

What about the data type question I asked in my last post?

As Gus stated, backup and restore would be the easiest. The catch would be if you only want the reference data moved into your development environment and you have...

Creating a SSIS project in BIDS instead of using the Wizard could help with building out a more verbose ETL process. You can use SSIS to assist with data...

The expression does not check the data type. You need to know what the data type is so that we can write the correct expression.

You can check...

What is your definition of synchronize? Do you mean a one-way sync for keeping a warm spare? Do you mean a bi-directional sync?

Why won't log shipping or replication...

Then I would use a Derived Column transformation in your data flow to replace the existing values with the defaults when they come into the data flow as invalid. ...