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:333117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm