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.
