Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

SQL Server Bulk Loader unable to find address for bcp batch

Highlighted
7 - Meteor

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?

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

Highlighted
7 - Meteor

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.

 

 

Highlighted
5 - Atom

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

Highlighted
5 - Atom

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

Highlighted
7 - Meteor

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

Labels