SSIS 2008 Transaction
Posted: 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 ?
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 ?