Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Copy bcp file in SQL via Alteryx

Asteroid

Hello,

Can we import bcp files in sql via Alterryx

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 
 
Labels