C
Casey
Hi,
I am importing a flat file into a remote database using ADO.NET.
First, I use a dataadapter to load the contents of the flat file into
a datatable. Then, I use SqlCommandBuilder to update the data into a
database table. I am doing this in development so the file and the
script are local, while the database is remote.
The flat file is only 16,236 rows, which I didn't think would be any
trouble. But on the first run it thew this error:
System.Threading.ThreadAbortException: Thread was being aborted. Each
time I run it now, it imports fewer and fewer rows, until the last
time, it only imported about 800 before it bombed out threw this
error.
I've updated the time outs in the .config files and in IIS. No
change. If I limit the original select to 100 rows, it works fine.
It seems like a timeout, yet it does not give a time out error.
Any ideas?
Thanks,
Casey
I am importing a flat file into a remote database using ADO.NET.
First, I use a dataadapter to load the contents of the flat file into
a datatable. Then, I use SqlCommandBuilder to update the data into a
database table. I am doing this in development so the file and the
script are local, while the database is remote.
The flat file is only 16,236 rows, which I didn't think would be any
trouble. But on the first run it thew this error:
System.Threading.ThreadAbortException: Thread was being aborted. Each
time I run it now, it imports fewer and fewer rows, until the last
time, it only imported about 800 before it bombed out threw this
error.
I've updated the time outs in the .config files and in IIS. No
change. If I limit the original select to 100 rows, it works fine.
It seems like a timeout, yet it does not give a time out error.
Any ideas?
Thanks,
Casey