It is a pseudo-data event framework designed to notify services of data change events. A simple example would be to use it for notifying customers of changes to their...

Ok, the variables in the script component:

Me.VariableDispenser.LockOneForWrite("User:startDate", vars)

should be:

Me.VariableDispenser.LockOneForWrite("startDate", vars)

Make sure you specify the variables in the ReadWriteVariables custom property of the script component.

Rather than summing information in a script...

Ok, here's my 2 cents.

Using a lookup component is straight forward and easy to maintain and will work for sources of pretty much any size (no problems with 10 million)...

Yes, I understood from the first post. The one server being able to see the other is odd. Check pinging the server name and make sure it resolves...

With no other difference moving from 32bit to 64bit, the performance difference will be entirely any increased memory made available. However, if you bought the old server more than...

Also, you can configure DNS to resolve your server names across the subnets correctly. In fact, it can even be configured to resolve across domain trust relationships if you...

Sounds more like a DNS issue than anything to do with mirroring.

Can you ping the IP address? If you resolve the name of the server (ping -a), is it...

Make the command:

SELECT ModemNumber, Charge FROM dbo.FixedCharges WHERE BillingPeriodID = ?

and then click the parameter mapping button to map your variable to the parameter.

I think it uses standard time UTC.

Is your timezone a 7 hour offset (taking into account daylight savings if necessary)?

Here is another post that may solve your issue:

http://www.sqlservercentral.com/Forums/Topic447196-146-1.aspx#bm447265

You can supply an operator with multiple email addresses - put a semicolon between them.

Oh, I did not read the post very well.

So I think you are saying that you have PK values already in your destination database that are coming from your source...

You may want to take the approach of scripting the referential integrity, dropping it, and then adding it back in after the data has been migrated.

Migrating the data in the...

You still have not given much information.

Typically, a fact table would not be populated from dimension tables, it would be populated from data in the source system(s), so I am...

I have, but not in an environment to really test any performance.

No problem, the "insert if missing" and "update if changed" ideas are really common to data warehousing. Look for information on maintenance of slowly changing dimensions. A Type...