What I'm looking for is the SQL code to actually transpose the data like this.  I've tried a couple of things this morning but without much luck so I thought...

Thanks.

The id does have rights to the share.

We have other .exes that run fine.  The only difference is that this one was written in VB and the others in C++...

Checked that already.  I'm using UNC share.  It just doesn't make any sense.

Thanks for the help Merrill.

Thought about that but when we run the job manually during the day we get the exact same error.

Logging into the server under the same account as the SQL Agent runs the exe.  The details of the job history are with the original post.  It indicates not being...

When looking at the SQL Server connection it is using Windows Authentication.  Could that be the problem?  We've got roughly 60 other jobs on this server and don't have a...

Not finding any issues with the permissions and I've looked for the quota information but haven't found anything so I'm having some of our IT guys look at that.

So to...

I'm sorry Remi, I'm not sure what you are referring to when you talk about quotas.

Jo, I don't think it is a permission problem but it could be.  I have...

Thanks Ray

Here is the table with the parts needed for this query:

CREATE TABLE [dbo].[ac_activity] (

 [acid] [int] IDENTITY (1, 1) NOT NULL ,

 [result_code] [char] (30) NULL ,

 [result_date] [datetime] NULL ,

 [result_by] [char] (20)...

Thank you very much Remi.  I was making it way to complicated to ever figure out it was that easy.  Thanks again.

Works great.  Thanks.

Hadn't thought of that but when I ran it I received the following message:

A COMPUTE BY item was not found in the order by list. All expressions in the compute...