How to use Copy SQL Server Objects Task?

• jenniferhu46

  SSCrazy

  Points: 2990

  More actions

  April 23, 2003 at 11:55 am

  #158877

  Hi,

  I need to copy 4 tables from one database to another, total size is 40GB. However, I only want to copy anything older than 2001. There's no place that I can write a little select statement in Copy SQL Server Objects Task, so how can I do this?

  And where I can find how many disk space left for me to copy such big table to another database, I mean, though Enterprise Manager?

  Thank you in advance.

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  April 24, 2003 at 3:14 am

  #455137

  Create empty tables in dest db (either script or use copy without data) then use dts to transfer the data with a where clause.

  Edited by - davidburrows on 04/24/2003 03:14:53 AM

  Far away is close at hand in the images of elsewhere.
  Anon.