Have made a few changes:

Only looks at databases which are online, also added square brackets by the "USE" statements in case a database has an illegal character e.g. a number...

Tried Googling it?

http://www.sqlteam.com/article/optimizing-performance-indexes-on-temp-tables

Assuming I've understood what you're on about you might have to do your delete as:

DELETE FROM dbo.cart C

LEFT OUTER JOIN

...

This help?

WHEN NOT MATCHED BY SOURCE AND

...

You might be suffering from parallelism. If you run this

sp_who2

And see several rows of the same SPID then there might be a parallel query issue

Then try this:

MERGE dbo.cart AS c_target

...

When you say "hanging" what do you mean? I take it as there is something blocking which in turn implies that the update would not complete.

Like I said, check any...

Have you seen why it is hanging? Is it being blocked by another process?

You're going to have a problem as it looks like you want to update a join key on the PO Table

Why do you want to update the PO Table? Which...

Trying to run a .NET statement in SSMS (?) :unsure:

Thanks for the tip but it doesn't seem to have worked. Basically my CLR is a modified version of this:

http://stackoverflow.com/questions/10325338/fastest-way-to-export-blobs-from-table-into-individual-files

jarid.lawson (1/30/2012)

---

I am not fully as familiar with SSIS yet. I have made a few packages, but I really have no more than the most basic exposure to it. After...

In essence I checked the flat file source and previewed the data. I saw that for some reason the odd numbered rows (i.e. rows 1,3,5,7,9 etc) seemed to be ignoring...

All sorted, it was carriage return/line feed weirdness :blush:

Seems to have been sorted. In the Excel source editor I changed the table source from the worksheet name to worksheet name $

So from "SourceSheet" to "SourceSheet$" and it worked...