Paul, How big is the DB on the 2000 server (how big is the MDB file).
Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Monday, April 26, 2010 5:23 AM To: cf-talk Subject: ssis 2005 question 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:333121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm