Groups | Blog | Home
all groups > dotnet ado.net > october 2007 >

dotnet ado.net : Error 'sqltransaction is completed. it no longer usable' in sqlbulkcopy.


Archana
10/10/2007 6:42:57 AM
hi all,

I am using sqlbulkcopy to copy content of csv file into table. I am
getting above mentioned error.

When i increase bulkcopytimeout this error is not occuring. So what i
am expecting is if bulkcopytimeout is not sufficient then it whould
give me timeout error and not above mentioned error.

Can anyone tell me why this is happening.

thanks in advance.
JIGNESH
10/12/2007 12:59:00 AM
Hi Archana

I am not 100% sure if its the same problem. but i wish you take a look at
http://support.microsoft.com/kb/912732

Regards
JIGNESH

[quoted text, click to view]
AddThis Social Bookmark Button