.SqlServerSave() support on MS SQL Server versions prior to 2005

[mickvikt]

.SqlServerSave() currently generates sql query for INSERTs/UPDATEs using OUTPUT INSERTED.* clause which is not supported by SQL Server versions prior to 2005.

I know that this is legacy stuff, but ETL.NET would be very useful for migrating necessary scenarios from ancient versions like SQL Server 2000.

Could the query be adjusted? It would suffice to execution an additional SELECT query like SELECT * FROM <table> WHERE col1=@val1, col2=@val2, <...> coln=@valn to achieve the behaviour of OUTPUT INSERTED.*. I guess positional arguments would need to be used as well here to support connections from ODBC/OLE DB drivers.

This could probably be implemented by creating a new node, e.g. SqlServer2000SaveStreamNode.cs and adding a new extension method, say .ToSqlServer2000().

[paillave]

I am working on something that can make it work against old databases. It will come later as I am quiet busy at my side.
Working on legacy sql server version is indeed a very high source of issues here.
Will let you know.

[paillave]

Something should be coming soon, it still needs some more tests