Tracey - your question is rather vague. Briefly some things that need to be known to even take a stab at helping you.
1. Design of the SQL table(s) into which the data is being inserted
2. Does the table have a clustered index
3. The code snippet that appears to be the problem
Then maybe someone can take a shot at giving you some guidance
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]