SSIS 2008 Transaction

rogomax · Post by **rogomax** » Mon 21 Sep 2009 07:39

Using ADO.NET SQLite driver inside a SSIS 2008 Data flow destination, if I select the Transaction property to "Required" and "IsolationLevel" to ReadCommited, the dataflow reports errors at runtime.
Transaction support is essential using SQLITE, if you need to export thousands rows. Otherwise performance are very poor.
The only way to turn round is writing a C# destination script inside the dataflow, using a transaction, making dotConnect driver useless (compared to the free SQLite driver) !

Is there a way to make transaction work ?

AndreyR · Post by **AndreyR** » Wed 23 Sep 2009 07:38

Could you please post here the error message and the call stack of the error?
Also I recommend you to take a look on this link, it may help.
http://faiz.kera.la/2009/08/26/ssis-tra ... -to-msdtc/