+1 This is indeed the way to go.
Another option, since you manage both servers: link one server to another and just do an SELECT INTO: SELECT * INTO newtable FROM 2KServer.db_name.dbo.table_name - Rex Mike Chabot wrote: > I would advise avoiding the migration wizard in SSIS. In my experience > it doesn't work very well. It is easier and faster to use the > backup/restore or detach/attach methods when it comes to upgrading SQL > Server. > > -Mike Chabot > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333145 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
