How to swap JTDS driver for MSFT driver for SQL Server?

[DebbieKat]

This just in. Don't use the truncate tables job entry either. Same deal. I guess it will have to be an actual sql statement.

[gutlez]

I thought that was how the option was intended to work...

Truncate the table before insert = Delete from <table>; Insert into <table> values (?,?,...)

[DebbieKat]

I thought that was how the option was intended to work...

Truncate the table before insert = Delete from <table>; Insert into <table> values (?,?,...)

I think it depends which connection type you use. I assume since this is a generic database connection it is using the least common denominator. Some databases don't have an actual truncate command. But delete logs everything and truncate does not.

[jbeal]

Delete from can generate some huge rollback segments and take a while if many rows relative to a truncate.