yeah. but in the wild is that reliable, testable et... On Mon, Apr 26, 2010 at 6:13 PM, Mike Chabot <mcha...@gmail.com> 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 > > On Mon, Apr 26, 2010 at 6:23 AM, Paul Ihrig <pih...@gmail.com> 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:333142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm