Unable to find address for bcp_batch Error

Question

Hi All,

I'm trying to bulk upload excel files into db using data steam IN tool, but I'm getting an error 'unable to find address for bcp_batch' also I have installed the SQL Server Native client but still no success.

Can you please help me out in this?

Thanks,

Ramandeep Singh

01_alteryx_Error.png

02_alteryx_Error.png

03_alteryx_Error.png

Magneto_ · Answer

My sql server native client does not have the permissions

jhueschen · Answer

Your third image shows it all.  You set up the 'bulk' DSN using the 'SQL Server' driver.  You need to remove/recreate and use the SQL Server Native Client 11.0.

Should fix it right up :-) (I had the exact same issue, see https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SQL-Server-Bulk-Loader-unable-to-find-address-for-bcp-batch/td-p/135821 for proper citation)

Aguisande · Answer

Hi @marwahraman

Can you share the workflow and data with us to look further in this case?

I was trying to reproduce this in  many ways, without success.

Please, let me know.

Best,

_AG_