difference between sql providers SQLOLEDB and SQLNCLI
- by salman
Hi Everyone
I just need to know what's the difference between sql providers SQLOLEDB and SQLNCLI. I have one scenario where one SSIS package should fail. Now when I use SQLNCLI provider in the connection string the package terminates by throwing the error as expected. However when I use SQLOLEDB provider, the package behaves abnormally by ending successfully without throwing any error?
Can someone shed some light on this scenario?
Thanks.