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 On Mon, Apr 26, 2010 at 6:23 AM, Paul Ihrig <[email protected]> wrote: > > hey guys. > i am in a pickle. i dont know sql server 2005, and i have to migrate from 2k > to 2005. > the ssis data migration wizard seems fine after i tweak packages. except for > 1 table that is throwing me. > > the table has 30000 records or so. one of the columns is of type image. > the package just runs for hours at a time. and i kill it because i dont see > any results at about 15000 records. > > how can i do this better? > is there an example you know of to loop through a migration? like 1000 > records at a time. > or using multiple threads. again i am newb so 2005 book recomendatiuons > would be fantastic. > > and linked examples that might help me. > > thanks guys. > -paul > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
