I imagine you have a reason for setting the variables as string in the package, but if not, why not just make them INTs?

Alternatively, create two new INT variables and...

That is just one issue, and the error message seems clear. This is running on the server and therefore (presumably) it cannot access that path when it runs.

OK, it's good that you understand the implications.

My experience with replication is limited, and therefore so is my advice! I think that you need to be monitoring what is going...

Sounds like a join. But without knowing more about the data and table structure, it's difficult to help any more than that.

Yes it matters. Put it before the statements you want it to apply to. It applies to all of the statements which follow it in the proc, unless you issue...

Here is a detailed article on the topic: http://rusanu.com/2010/03/26/using-tables-as-queues/

Can't see an easy way of fixing that. Seems that the Excel code does not allow you to specify the delimiter and instead picks whatever you have in Regional Settings.

The...

I think you've been a forum member long enough to know that "it didn't work" doesn't cut it as a technical reply.

Change the delimiter from a comma to a pipe to avoid that issue.

Use square brackets:

CREATE USER [DT-SERVICES-TEST] WITHOUT LOGIN;

As Jonathan AC Roberts mentioned, this is difficult without knowing more....

OK, what I was angling towards is this: can your process be re-engineered to process all currently unprocessed rows in the queue, rather than picking them off one by one?

Do you execute one or more procs for every row hitting the queue?

It might be helpful if you would elaborate on the 'performance issues'. Are we talking CPU, disk access, locking/concurrency, parallelism ...?

What makes you think that the cursor is causing the...

The query you have provided contains both a subquery and a ranking function, so I don't understand what you are asking for.