Thanks, I probably should have noticed the job steps. I will look into both options.

Thanks again.

First - thanks for the response.

In the example you give the date is the same for both start and finish so it will never return any records. I can just...

Thank you. That  is exactly what I needed to do. I created a template file and used that to set the connection to the excel file/sheet. I had tried this...

Wow - that was really stupid. It was the name of course.

Problem is resolved. I had changed the server name to the server\instance name at some point and it didn't work. After trying the BCP utility and receiving similar errors I...

Same result.

So I wasn't able to change the account until this morning. I changed the account to use my credentials as I did on the QA machine while testing. As expected...

I thought about that and yes it did work when I used my credentials on the dev machine but it also worked as the local system account. I thought it...

Yes, thanks Orlando.

Originally I was trying to run the package through a stored procedure using xp_cmdshell. I believe the stored procedure uses the SQL Server Service. I then tried executing...

I guess I didn't see how it helped because I had already made sure that the system account login in SQL server has access to the database. I also created...

Thanks, I did that and the job completed successfully.

I will admit I am not sure how that helps me.

Thanks for the link.

My inexperience may show here with my questions/responses but in response to the options presented in that kb article:

I am not really sure how the proxy would...

thanks but that is a link to this page.

I am running it from a stored procedure, not a job so I think it is using the SQL Server service, not the agent service.

I did notice that the...

No - it is on the same machine. That machine also has only TCP/IP enabled currently. I tried enabling Named Pipes so it was consistent with my QA machine and...