I have a similar situation here. Instead of col limitation, I have row limitation which is to limit different user to only see their subset of data. Another complexity is...

We have a dev app server (dev400) that has 2005 client installed.

One of our developers is writing 2008 ssis pkg and need to execute this pkg from this server (dev400)...

The same msg is in the sysmail_event_log and I didnt restart SQL Server Agent.

Thanks.

I was able to send test email with no problem.

This is mainly from application.

Not sure what is 'Transaction is no more valid.'

How can I tell if the node added correctly?