I am using the code below to change the connection. Do you have an example how I would use ActiveX to change the table names.

Function Main()

dim PKG

dim SQL

set PKG =...

I thought a solution might be to use left(remarks,7000) on the source field but this made no difference. I thought I might then try to trim trailing white space in...

Thanks, will try that out

I also find that if I close the parent package and run it, it does not fail. But if I select the sub package in the parent and select execute...

Thanks for the advice re deleting connections.

Regarding the error, yes, the sub package executes ok by itself.

Thanks for your replies - I have had a play with both methods and seems fairly straightforward and lots of possibilities.

Sorry, I did not make myself clear. I meant a temporary table as in #Temp

Ray, I changed the time to 22:05 and this morning it is working ok.

Many thanks

Stefan

Thanks, do you have a simple example to get me started?

So what this means is that all code contained in a procedure is a single statement and therefore treated as a single transaction.

I guess the safest thing to do...

Thanks Guarddata and Rdfozz. I have learnt a lot from your answers.

Just one final clarification.

In the book I am using, it suggest that AutoCommit will treat each SQL Statement as...

I tried

DECLARE @Loop int

SET ROWCOUNT 1000

SELECT @LOOP = 1

WHILE @LOOP > 0

BEGIN

 BEGIN TRAN

DELETE FROM tblStatistics WHERE STATYEAR <= 2004

SET @Loop = @@ROWCOUNT

 COMMIT...

The conclusion from the replies seems to be that the example should not work however I have tested it and it does BUT and this was the reason for my...

Have you got a primary key on the table? The table will be read only if there is no primary key. Also once you have created a primary key you...

What can I say? It's so obvious when you see the answer. I have never come across Truncate before.

Thanks