I have a execute sql task in ssis and it performs poorly. At any given time it's inserting between 500 - 50K records. Its taking over 2 minutes each time. Is there a way to improve the performance? I'm using an ADO.Net connection. Any suggestions and help is greatly appreciated.