OK thank you, Grant, that is a good point, and thank you for replying. But then if I wanted all the data from all the tables (I should mention that there are 3 different schema's in the database so a database backup/copy is not really helpful), what should my approach be? I was planning on creating an SSIS package, with a DFT for each table, time consuming, but reusable. Would you have a better method for me to try?

Regards,
D.