HAHA, I will try that to see what happens. damn sa gets everything, even though my account is an SA account, I'll try it anyway you never know

I see why you would say that the paths are wrong, but the paths without files are variables that just hold the bulk of the connection string as I'm using...

I was afraid of that, but from what I have deduced from what people have told me here, there are never any issues with it, but taking advice from people...

Owner of the job is my username, the job history error is one that I was getting before but I finally fixed that yesterday by adding my username to the...

Thanks for your help Welsh, I will note how Welsh, Steve and Ken helped me finally fix this. Just like Welsh suggested with this link (http://msdn.microsoft.com/en-us/library/ms178142.aspx)

Step 1: Log...

Since I'm an admin on the Sever box, I can just pull a user out of the directory and give them rights and then use them as the account that...

To be honest welsh, I am the first person to actually use SQL Server Agent jobs in my shop. I come from other shops where I could add a job...

Thanks Ken, I will make sure that it checks for a valid connection first and no I do not have any password inside the package. The only thing that does...

Thanks for the help Ken and welsh, I changed the "Log On As" back to local system and am Logging in as ".\Administrator" for the SQL Server Agent. I ran...

The reason you see .pdf and not a file name is because I'm using a foreach loop that creates the file name dynamically using a variable based on what is...

You are right, the package that I am running tries to access files from an FTP, tries to access files from another server and tries to write files to another...

Yes the file is located on the server machine and I also have it on my local computer.

Hi Ken, thanks again for your help, I have changed the Log On As drop down to show Local Service, It was on LocalSystem before. I have attached a picture...

Hi Ken, how would I logon into the server as the Service agent? I'm not sure how to do that, if you could provide me with another methodology like previously...

Hi Ken, Yeah I know its the default and since I've been having these crazy issues I might as well try not saving any sensitive data just in case it...