SQL Bulk Loader on Server while using the API

neel-s — Thu, 28 Oct 2021 21:54:23 GMT

Hi All,

I have a workflow that reads in XLSX files from a shared directory and inserts them into a SQL table using SQL Server Bulk Loader.

When I run this workflow manually in the server, it inserts data into a table but when I run the workflow using Alteryx Gallery APIs, the job fails. If I replace Bulk Loader with Data Stream in and Write Data in DB tools, the workflow writes to the table no matter how it was triggered.

Has anyone faced the same issue with the server? I have DSN set up through Native Client for Bulk Loader on the server.

Re: SQL Bulk Loader on Server while using the API

BrandonB — Mon, 01 Nov 2021 20:52:15 GMT

Maybe this has to do with how you have the Bulk Loader configured. Do you have the Data Stream In tool set to use the Bulk loader connection?

topic SQL Bulk Loader on Server while using the API in Alteryx Server Discussions

SQL Bulk Loader on Server while using the API

Re: SQL Bulk Loader on Server while using the API