Copy bcp file in SQL via Alteryx

[tjamal1]

Hello,

Can we import bcp files in sql via Alterryx

[afv2688 · Accepted solution]

Hello @tjamal1,

You could use bulk loader on the database connections. This post tells you a little about it as well as best practices:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Loading-to-SQL-Server-Database-3-4-Bil...

Another option would be if you have it installed on your machine you could use the run command tool to do it. You can see here if you don't know how to perform those actions on a command window:

https://www.sqlshack.com/bcp-bulk-copy-program-command-in-action/

Regards