-
-
Notifications
You must be signed in to change notification settings - Fork 89
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
.SqlServerSave() support on MS SQL Server versions prior to 2005 #449
Comments
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. |
Something should be coming soon, it still needs some more tests |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
.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 ofOUTPUT 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()
.The text was updated successfully, but these errors were encountered: