tblTempImport is a 20 column all VARCHAR(255) table that actually gets the data 10 out of 10, so the import is working.

But soon after the import is finished I get the following error message exactly 21 times (and one more time soon as I close the application):

As an additional detail I tried on a different MSSQL Express (2008) instance and It worked with no problems the first time, after the first time every single time its it generated the same error even after restarting the application.

A work around (which I would rather ditch for a solution) is to go by:

Try adding a unique "primary key" field to your table. Many databases rely on the primary key for many tasks. You may be able to solve this problem by making one of your fields a primary key. This is a quirk of client-server databases. The easiest way to do this is to use an AutoInc type field which will always be unique.

Neosoft Support wrote:Try adding a unique "primary key" field to your table. Many databases rely on the primary key for many tasks. You may be able to solve this problem by making one of your fields a primary key. This is a quirk of client-server databases. The easiest way to do this is to use an AutoInc type field which will always be unique.

That error doesn't happen with other database engines, so I'm not sure exactly what to suggest. It could be that the bookmark error is caused by the index being out of sync with the table's contents after the deletion. Here are some suggestions:

You could try using DBPro's dbpDeleteAll action instead of doing it through SQL (which happens outside of DBPro's influence):