And...how much memory is in your server?

Do you know about VAS and MemToLeave? Chances are you're running out of VAS.

Run this query and post the results please:

WITH VAS_Summary AS

(

...

Please start a new thread 🙂 The OP wanted to know if it was possible, not how...

You can use SQLCLR aggregate GROUP_CONCAT to do this (get it here http://groupconcat.codeplex.com):

SELECT jc.OrderNum,

dbo.GROUP_CONCAT(DISTINCT OrdCountry) AS OrdCountries

FROM #JobCountry...

32-bit or 64-bit SQL Server? How much memory does your server have in it and what is the max memory setting in SQL Server?

Yes, it is...

Elliott Whitlow (6/27/2011)

---

opc.three (6/27/2011)

---

Not leaving SSIS for PGP tasks would be preferable. And I agree, downgrading would probably be an easy thing to do. Just for completeness, I did a...

Elliott Whitlow (6/27/2011)

---

opc.three (6/25/2011)

---

http://ssisextensions.codeplex.com/ is 2008 only.

Cozy Roc has a 2005 component but I just looked at it and it appears as if it support OpenPGP only, i.e. it does...

Excellent, remember this when it's your turn...

Ninja's_RGR'us (6/27/2011)

---

Sean Lange (6/27/2011)

---

I do know what to do on each layer and trust me you both are wrong, no other data engine, or layer, linq, entity framework, Datasets loops...

I do love them, like hangnails, and splinters 😀

From http://en.wikipedia.org/wiki/International_Data_Encryption_Algorithm:

IDEA was used in Pretty Good Privacy (PGP) v2.0, and was incorporated after the original cipher used in v1.0, BassOmatic, was found to be insecure.[2] IDEA is an optional...

GilaMonster (6/26/2011)

---

Except that the perfmon counter doesn't actjually track...

GilaMonster (6/26/2011)

---

opc.three (6/26/2011)

---

Snapshot iso is the other level you could consider. It is the only other read-consistent iso level besides serializable. I say consider because I have never looked at...

I always use PerfMon, not sure if it's available in a DMV. If you find a DMV/F please post back 😀

Serializable would keep you from getting dups. It is super max lockdown though so using it would defeat the purpose of running two instances of your code as it is...