SQL Server Bulk Loader unable to find address for bcp batch

[MaverickVZ]

I am trying to use the SQL Server Bulk Loader option in Alteryx 11.7.4. I created a Dsn connection and it tested ok. I then tried to use it to load a file to the SQL and received an error : unable to find address for bcp batch. Can anyone explain what that means and how to resolve it?

[CharlieS · Accepted solution]

What driver are you using when you configure your DSN? We've only had luck with the SQL Server Native Client driver for bulk connections.

[MaverickVZ]

CharlieS, THANK YOU!! That got transferring .5 M rows down to 53 seconds from over an hour, I was using the SQL Server driver.  I used the SQL Server Native Client 11.0 driver and it worked. I appreciate the help, thanks again.

[JPL]

Yes, Charlie S, thank you very much! I probably wouldn't have figured this one out without you.

[pmacouzet]

Your reply saved my day. We can now load 8 million records in 10 seconds. Thank you.

[HiralMavani]

Is there any reason why it doesnt work with SQL Server driver ?