In SQL 7, you can use the DTS wizard