I was doing a search on your error and found this forum post http://forums.asp.net/t/993765.aspx. I'd see if that helps..

CEWII

Quite frankly I probably wouldn't recommend BCP for experienced developers.

Linked server is ok for fairly small amounts of data but if we are talking more than a couple 100,000 rows...

I think your problem is you seem to be misusing the grant statement. I checked the syntax to be sure and what you appear to be doing is only...

XLS or XLSX? What version of excel are you using..

CEWII

Ok, so you have a file that is in excel as an XLS file, not CSV or something goofy like that. IT is a realy XLS file?

Are you able...

That is exactly what I was going to suggest.. Synonyms are a great way to "hide" exactly what is on the other end and this is a perfect example...

Do you happen to have the spreadsheet open in Excel at the same time. I have seen that cause trouble..

CEWII

If you use windows file encrpytion then ALL file access especially writes become sequential. I'm not saying not to do it, but there are performance consequences.

Also, to be honest...

Is this something you are doing once or often. If it is once you might look at the Import/Export wizard and let it do much of the heavy lifting....

I really must push AGAINST cascading deletes, it makes it way too easy to delete data that you really didn't mean to or even know would be deleted..

CEWII

Are there indexes on the table? Are the indexes on fields in your where clause?

CEWII

That was a pretty good article. And I always like articles that agree with me..

CEWII

xp_sendmail uses MAPI to send email, and sp_send_dbmail uses only SMTP.

Keep in mind that xp_sendmail requires a client such as Outlook to be installed on the server which was ALWAYS...

How much memory do you have?

I'm trying to think of things that could be causing trouble and that is the most obvious. My machine has 2GB.

CEWII

Write them to a table or a file. About the only thing I think you could indicate is success of failure coming out of the package to DTExec..

CEWII