Thanks John. Sorry for the confusion, I changed the object names for security reasons. I have amended the SQL in the post now. I tried your suggestion, and as I...

Well thanks for all your replies, and I think Jeffrey's has hit the nail on the head. The only inserts are to table variables, no other updates or deletes. and...

Thanks ALZDBA. Basically, the stored procedure builds up a string based on various criteria, then simply runs it as follows:

.

. code to build @Query string

.

Begin Tran

Execute (@Query)

Commit

Within the string, it...

Not intending to bump my post, but...

Just to clarify, I have inherited a product which makes extensive use of stored procedures. Would I be right in thinking that the original...

I agree, a good article for beginners.

Don't know what all the fuss is about. I am fussy about grammar and spelling, but it wasn't difficult to work it out.

Thanks for the comments, I think Markus' comments sorted me. Sounds like when you copy a backup to another PC, whilst you can restore from the backup, you cannot regress...

I will do that later in the week/weekend if that's OK. But it was pretty easy, I have only been playing with D.T.S. for a week, so if I can...

Sorted.

Just in case anybody is interested; I have created the packages using VB.Net, after initially saving them as VB files. I can then access an environment variable and store the...