It's another domain account.

Same sort of workround as me then, but thanks for the response. I think my colleagues would find bcp more intimidating than SSIS - I have shown everyone how a...

I suppose I'm going to have to overcome my distaste for HTML email then 😉

Mark-101232 (1/8/2010)

---

WITH CTE AS (

SELECT Customer, MAX(Trx) AS Trx

FROM MyTable

WHERE Trx IS NOT NULL

GROUP BY Customer

HAVING COUNT(DISTINCT Trx)=1)

UPDATE m

SET Trx=c.Trx

FROM MyTable m

INNER JOIN CTE c ON c.Customer=m.Customer

WHERE...

Lynn Pettis (1/8/2010)

---

Scott-144766 (1/8/2010)

---

Starting with

Customer Trx

A2 124

A2 ...

Thank you very much.

Scott

JStiney (11/20/2009)

---

The following is a much more flexible and much more useful version of sp_who/2 that I have been using for a number of years.

/* Author: Richard...

Have you everted time too? This was posted a week in the future...

Have you tried using the GZIP component native to .NET libraries? You can get to it via the script component, which I use often and without issue. I...

I've gone down the xp_cmdshell route and it's working. It's a shame as it feels like a much less elegant solution but it's doing the job so I won't complain....

No, there's no logging option. I'm open to using other zipping tools, especially if they're free!

I'll try that, but I'm sure it's the zip that's failing. The text files are written to disk but the zip file isn't.

The job step never completes so there's nothing in the history (apart from the stop job request I have to issue). The package runs in a couple of minutes but...

I'm usually discussing ways of keeping my trousers from falling down. My father-in-law is a carpenter...

Looks great, but I must admit I find it hard to take the name seriously. What next - Ultimate Fighter tote bag?