Unable to find address for bcp_batch Error

[marwahraman]

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

[Aguisande]

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_

[jhueschen]

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-... for proper citation)

[Magneto_]

 My sql server native client does not have the permissions