Does this work with TempdB as well. My TempdB is getting really huge. I tried shutting down, and even though it made some difference. the dB is still way too...

I'll give the Fastload a try. The SQLAgent uses a special id 'Jobadmin' with similar privileges to SA, so that shouldn't be the problem. Nor the timeout. It always chokes...

Interesting, as I have what could be a similar problem that I was just going to post:

 I have a DTS job that executes just fine when executed manually, but fails if...

That is, as long as your expected record size is within Excel's limits. I sometimes drop the data into a SQLServer table and then link to this table from within Excel using External Data Source and...

Thanks - it works!

Interesting article - as it confirms my thoughts on the use of SQLAgent! Looking forward to the next installment

Thanks guys! Works beautifully.