Thanks for that James, however I want to preserve the tables that are already in each DataFile. Doing a shrinkfile will move all the tables into one DataFile.

Thanks for the replies Peterhe. I cannot use xp_cmdshell as the use of this is restricted at work. I also cannot just use exec as I need to get a...

Thanks Jon,

Thats worked OK. I was missing the join back to the ID in the original table.

chuz Mark

Thanks Darrell,

The change in syntax works fine now. And the global variable is working today aswell. These little things can be so frustrating.

Thanks for your help.

chuz Mark

Thanks Jonathan,

1 - I am trying to set the tablename value dynamically from a table which changes daily, so an ini file is only adding to the complexity.

2 - I...

Thanks a load Edwin. That does just what I need.

chuz mark

Thanks for the reply Edwin.

The reason I would like to execute the step in the loop is that the next step is a dynamic properties task. This uses data...

Thanks for the reply.

The problem is not that it does not loop. The msgboxs display the changes OK.

I cannot get another DTS step to be executed for each iteration of...

Thanks for all your replies. Some of the SQL and code has given me some useful things to work with.

chuz Mark