And perhaps you should test your own code too?

Yes, I...

Glad I could help.

Ah. Yes. Pivot does require aggregation. Sorry. I didn't realize that's what you're doing.

Hmm. Now I'm wondering if there's a way to trick Pivot into doing an aggregation that isn't...

Bleargh. I had a feeling that was going to be the answer.

Oh, well. If I hadn't asked the question, there would have been an alternative. @=)

Thanks, Gail.

So many potential solutions. I like Steve's solution stuffed in a sub-query and broken out into separate columns. Then just do a count in the outer query and group by...

Column List in the SELECT part of the...

Do a search on phrase "Dynamic Pivot". See if that helps you out. Then post back on this thread with further questions about it.

Glad I could help. Let me know if you have any more questions regarding this issue.

Well that depends on where the .exe file is located. If it's on a UNC or Share drive, you just need to add the proxy account to that path's Security...

Does the proxy account have permissions on MSDB to execute the dbmail procs? Does it have write permissions on the share where the log file is kept? Does it have...

Nevermind. We have a clustered server and the users in question keep getting shunted to the node that isn't quite working right. When we have them use the literal address...

Maybe I'm misunderstanding, but failed jobs can send out Notifications which...

That's your problem right there. You cannot save the password for that login when using "DontSaveSensitive". The point of that protection level is that the package does not save passwords....

TravisDBA (7/8/2010)

So I spend the first week reading up on the database, then find myself receiving troubleshooting emails. So I ask my co-worker (the only other DBA team on the...

What's the package protection level set at? Does the Developer have permissions in the SQL Server that he's running the package against?