If I understand this right, both you and your clients are free to modify the schema of your respective databases, and you need to synchronise data between client and server....

Mark Harley (5/27/2009)

---

I have to create a DTS package to send data to a client on a nightly basis. The data has to be taken from two applications. ...

The question is unclear.

It might help if you design the DTS package to execute each block of SQL as a separate step.

You might find it easier to us SSIS, too.

This is the T-SQL for creating a job. You will need to edit for servername, login, filename etc.

You might have just missed the option for running a SSIS package, so...

jain_abhishek (5/28/2009)

---

Hi My Database is filling very fast and due to this it creates problem.

I have one more drive on the computer which is E: drive.I want to move some...

The row_number() function is better, usually quicker, and more flexible.

I work with Contact Centre data, and do this every day of the week.