Thanks

I ultimately found that solution and hadn't had time to come back and post.

Thanks for the help.

Thanks. That did it.

Here's what my Edit Group screen looks like:

I have no...

Yes. THat was the approach I took.

I was just coming back to post that I'd arrived at that same solution. Apparently a moment of clarity.

Thanks.

Another thing to try...

That update query was kind of a "Duh" on my part. For some reason I just couldn't see it. Going on vacation Friday. Maybe my brain has already started...

Loading the...

One of those stupid things you know but don't see when you're looking at the code.

Thanks.

Hmm...

I dropped the Transform and added it back in and now the job is running. Maybe there was a disconnect between the "Drop and Create" table name and the named...

That's what I'm doing and it isn't working...

The following code will set the cursor and lock types and allow correct access to the RecordCount and Return Code (Parameters(0)):

set pcmd=server.CreateObject("ADODB.Command")

set rs1=server.CreateObject("ADODB.RecordSet")

pcmd.ActiveConnection=ttconn

pcmd.CommandType=adCmdStoredProc

pcmd.CommandText="dbo.GetLeaders"

pcmd.Parameters.append pcmd.CreateParameter("RETURN_VALUE",adInteger,adParamReturnValue)

pcmd.Parameters.append...

Removing the semi-colon didn't matter, but my code was depending on RecordCount to proceed. I changed it to just ignore RecordCount and read until EOF and I got back my...

I added a RETURN at the end of my SP with no change. Thanks anyway!