I don't know if this helps you, but your query needs to be fully qualified when using a linked server.  for example, I link to another sql server, so the...

Make sure that the package owner has the ability to run under the correct security and execute the package.  Also, remember that if there is any file system activity going...

Try this program http://www.emailarms.com/products/1st_smtp.html - it looks like it will connect directly from the server that way or you set it up on another pc and relay the messages to...