Error 'sqltransaction is completed. it no longer usable' in sqlbulkcopy.

  • Thread starter Thread starter Archana
  • Start date Start date
A

Archana

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IsZombied (This SqlTransaction has complete; it is no longer usable.) 1
This sqlTransaction has completed; it is no longer usable 10
Exception: The SqlTransaction has completed; it is no longer usabl 5
This SqlTransaction has completed; it is no longer usable. 3
SQLTransaction Commit method 2
SqlTransaction rollback error 7
SqlTransactions and Sql timeout errors 8
Insert quits when exception is thrown 3

Back
Top