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

paillave / Etl.Net

Mass processing data with a complete ETL for .net developers

https://paillave.github.io/Etl.Net/

MIT License

631 stars 89 forks source link

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

Open mickvikt opened 1 year ago

mickvikt commented 1 year ago

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 commented 1 year ago

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.