How to use BCP load for MS SQL server in Talend?

[Anonymous]

Hi,
Could someone advice in talend how to use bcp load utility for MS SQL server in Talend?
I can only see the following options I have.
Bulk insert
Bulk update
Bcp query out
Your help is much appreciated!

Peter

[Anonymous]

Hi Peter,
I m using BCP for Sybase SQL server and I can load data using this option . What is the problem are you facing other than this options what are you looking for
Regards
Anr

[Anonymous]

Hi, Anr,
Thanks for your information. I want to use BCP in MS SQL server instead of Sybase, but I don't see this option in SQL server compoent.
Could you please advice? Thanks.
It is urgent for me. Your help is much appreciated!
Thanks,
David

[Anonymous]

Hi,
Anyone can help? It is urgent for me
Thanks,

[Anonymous]

Hi, Guys,
Can someone help? How about Talend Support?
Your help is much appreciated!

Peter

[Anonymous]

You could use the tssh commands and then use the commands from the below blog to use the bcp commands.

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