Incidentally, environment is SQL Server 2000 (Service Pack 4) on Windows Server 2003 R2 (SP2).

I've seen a few solutions where SQL Server has been patched up to SP3 or below,...

This should do what you're after 🙂

SELECT Product, April, May, June, April+May+June as 'Total'

FROM MYTABLE

ORDER BY Product

A possible suggestion is that the account executing the package via SQL may not have the same permissions as you have yourself when manually executing.

Maybe check the account which is...

Yeah, whatever conditions you need to create in the job, just build them into an SSIS package, and then fire it off with the trigger?

It's the server firewall that would have to be turned on or off.

I would think it unlikely if you can connect on an alternative PC though to be honest.

Is the...

No probs, better to avoid posting server names on an open forum anyway I guess 🙂

Have you tried the firewall to rule it in or out?

"Cannot connect to XXXXX."

Apologies if I'm off track, but is the actual name of the server?

It sounds like it is the name of a database, rather than the machine it...

Can you browse to the server (name) in management studio with the connect to database engine dialogue?

What is the actual error you get when you try to connect?

Best solution is to use a trigger if it is a specific event in one table.

Create an SSIS task for the Email alert, using the "SendMail Task"

In the command prompt, type:

nbtstat -A (IP ADDRESS OF MACHINE)

See what it resolves as the host name

Could be one of many things really...

Sounds more likely to be a DNS issue than a SQL issue?

Try checking file-stalls and top waits on the box to see if anything stands out;

-- Helps determine which database files on the entire instance have the most I/O bottlenecks

SELECT DB_NAME(fs.database_id)...

Nice one!

And no problem 🙂

Hmm, personally I would say that 30 minutes to build an index on 280 million rows is not so bad performance at all really, was this for a clustered index?

Are...

Couple of things you could try;

1. Try adding the user's account to the Distributed COM users group on the server.

2. Check MsDtsServer in Component Services:

add all permissions for msdtsserver for...