SQL Server Bulk Loader unable to find address for bcp batch

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?

Database Connection

Accepted answers

CharlieS

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.

All comments

CharlieS

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.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167