Morchella, I'm not sure what to tell you... importing explorting image data types means a lot of binary data flowing through the drive and very large prepared statements.
-mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Morchella Deliciosa [mailto:[email protected]] Sent: Monday, April 26, 2010 2:03 PM To: cf-talk Subject: Re: ssis 2005 question just under a gigabyte. i need to find an example on getting record count of source table and looping the inserts say 1000 at a time. right now its just delete destination grab source and insert into destination. but google is failing me.. ssis loop recordcount insert ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333135 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

