Hello,

I am trying to mass import data using my application.

For each record, I create a connection, transaction, process data,
commit transaction and close connection and am also disposing these
objects.

I have about 100,000 records.

After a few hundred imports, I get weird, inconsistent errors everytime
I run the app. I was wondering if creating and disposing these many
connections and transactions could cause memory leaks etc. Anyone?
Microsoft?

Thanks,

nashak (AT) hotmail (DOT) com wrote:

so for 100000 records u create this much connection?
Look at ssis forech loop container, it will help in this case.
What is type of source data?

Regards
Amish Shah

I understand your concern. Hence here is some more info

this is the initial data import. I am using current logic to insert
rows. Normally this procedure will be called 2-5 times a day and hence
the procedure will run fine.

Hope this allays your concern about 100,000 connections being created
and disposed


amish wrote: