UNC path worked...thanks!

The directory is there all the time.

I'll try the UNC path.

Kinda wierd tho, cause it does work fine when the end user drops a file in..

Here's the error..works fine if a file is there..

Corp 1984-2005. All rights reserved. Started: 12:30:59 PM Error: 2012-09-13 12:31:00.10 Code: 0x00000000...

I'll check them both out.

Thanks Grant.

yeah it was a rights thing...

thanks for your help..

Yep that was it!

Thanks guys ...really really appreciated!

I know now that my problem is in this part of the statement:

SELECT DATEDIFF(YEAR, EecDateOfOriginalHire, getdate()) from empcomp EC WHERE EC.EecEEID = eepeeid

awesome thanks guys for all the help

thanks for answering/helping...

recovery model is set to full

It's set to grow by 10 percent.

got it thanks!!

Thanks Jack..

My guess is another job(s) running...

We are checking now...but we wondered if it could be anything else.

prefect thanks!

I figured it out..

thanks guys..

Thanks Lowell!

Your stuff is always so good. Wish I had read your reply before I started on what I wrote:

;with cte as (SELECT

E.eecCoID AS 'Rec ID',

E.EecEEID AS 'Emp...