Most likely they're validating. Turn on Delay Validation.

Also, make sure you're using what's become a defacto standard for SSIS called procs:

SET NOCOUNT ON;

SET FMTONLY OFF;

WHILE 1=0

BEGIN

-- Result set for...

I've been consulting for years, and every now and then this lovely little item pops up.

I ignore the 30 minute calls on the weekend if I don't have to login...

Merge is, generally, better than hash.

That said...

You mentioned you created new statistics, but did you update with fullscan? On BOTH systems? I'm wondering if the Test system is...

PIVOT

Not sure if you're still on this thread, Tavis, but that's a neat trick. May require some on the fly trickery to my base data to NULL, child the...

Like will perform more optimally when used like a LEFT(). Otherwise they're both going to scan. LIKE I believe has a better chance of using Full Text Indexing...

Depends on the best practice....

For SSIS, there's a few things I recommend. Most of them revolve around Configurations.

I know why standards exist and mostly that's to keep some nut with his own idea...

As usual, it depends.

Replication uses locking like anything else. Even if you have a row filter on, unless that's a VERY small row filter (5000 rows or less), the...

I would say no. Random code samples are a poor method, simply because a lot of what we do *is* simple and doesn't need a lot of exposition or intricate...

This is an article of mine, but it may help you a bit:

http://www.sqlservercentral.com/articles/Career/71608/

Offhand, I have no idea and you're dealing with some really idiosyncratic glitch. I'm relatively sure you won't know for sure unless you call Microsoft and they look into...

Tavis,

That looks awesome, and similar to where I was probably going to end up with self-referencing proc calls but this looks a lot cleaner.

Thank you for this. Once I...

Ugh, not a fun process, particularly when row order matters. Don't feel bad about struggling with it, it's neither obvious nor simple.

Basically you're looking for the quirky update or...

J,

A few things.

One, your code seems incomplete. There's BEGINs without ENDs, and there's no real reason to have them there.

Next, your query plan is incomplete. As...