That would ensure that data flows through SSIS in the order that you have specified, yes.

But say it loads it into a target table called MyTable

If you then select it...

Yes SSIS will process it in the order that it finds it (or in the order that the source driver returns it). But you need to remember that there is...

Server is infected with a virus and you are relaying Viagra spam

I thought you already configured database mail? Are you still getting the original error or are you getting both?

You will need to be methodical to solve the issue.

Do you know if your SMTP server requires authentication? If so do you know what the username/password is, and did you configure database mail to use it?

Go through the troubleshooting...

xp_smtp_sendmail is a thrid party stored procedure and is not installed by default (though it has become the defacto method of sending email)

It has nothing to do with database mail.

See...

That makes sense - msdb is the repository for the code that is run in test/production, and is not an area that allows you to edit. Makes good sense...

Out of interest: when working with packages in MSDB, is there any easier way of editing a package than having to export the package to DTSX?

I was suprised when I...

I'm suprised no one has suggested viewing the query plan for the query in question.

For example it might have made the IN subselect fix more obvious.

After using SQL Server for some time, I found that studying properly for the certification filled in loads of knowledge holes for me. It was the best thing I could...

Someone appears to have drawn some inspiration from your article.

http://subhrosaha.wordpress.com/

Sorry I can't but I know there is a good article on performance monitoring on this very site. Maybe someone else can post it as I don't have the URL...

hehe there is a lot of bullshit around thats for sure 🙂

It appears sound but if course with that much resource headroom you won't know if its an issue until...

The question is: are there any performance issues with what you currently have? Are there any resources left over with what you have? You need to analyse how the system...

Assuming it is a security issue, you'll need to mess with it to get your SSIS package working.

Normally you would actually create a specific service account and use that. Normally...