Problem when generating SQL for .SqlServerSave when using ODBC and OleDB connections

[mickvikt]

There is a problem with generating SQL, since ODBC and OLE DB connections do not support named parameters in INSERT/UPDATE queries. The parameters need to be replaced with ? symbols in the queries.

I've raised a sample PR showing a way how this can be remedied. Could we have something like this: https://github.com/paillave/Etl.Net/pull/442/

[paillave]

millions thanks for this contribution; I will have a look. Nevertheless, I am currently working on a fix for odbc and oledb that can be used exactly in the same way that nativesql (with some manipulation of the query). Therefore, the usage would be more straigth forward, and the switch from a connection type to another doesn't involve any change in the etl process description.