I'm trying to bring records across, periodically - so I am marking them with the date that they move, so next time they are ignored.

I am using transactions hopefully to...

Thanks - I will have a look.

Thanks - from above - say this was just a simple one table TRansform Data Task - which moved records from A to B

If it finds no records to move...

Thanks Greg - I'll have a further look based upon your advice.

No doubt I'll be back soon - with another not quite as dumb as the last time question.;)

Thanks

Hi, multiple tables' data based on criteria (ie only certain records.

So some of the fields from table A...C...F where ID = ? into corresponding fields in table(s) on target db.

Thanks very much Greg, I now have a bit of a clue what I'm doing, and a lot of reading up to do.

Thanks

Thanks both of you - I originally tried DTS but couldn't get the connection, I assumed it was a 2005 problem like ep connecting to the 2005 server.

Anyhow thats sorted...

The column links to a record within the same table - in some cases itself in other cases a differnat record.

Ps I haven't had chance to try solutions as my...

When the user specifies another value - I suppose I could set a default on the table field in that case?

That is all the information.

I want to set a field value equal to the identity field on insert of records. (the field may in other circumstances have a valiue other...

Hi - Thanks - but I don't want the value always to be the same as the identity - only in certain circumstances.

Thanks for the replies - if I go for ## does it still allow users to run the sps at the same time and create separate tables - and these...

Ta