topic Re: How to use BCP load for MS SQL server in Talend? in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 13:07:00 GMT

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

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

Anonymous — Tue, 01 Feb 2011 11:46:18 GMT

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

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

Anonymous — Tue, 01 Feb 2011 15:39:08 GMT

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

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

Anonymous — Wed, 02 Feb 2011 18:41:43 GMT

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

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

Anonymous — Sun, 06 Feb 2011 21:02:30 GMT

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

Peter

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

Anonymous — Fri, 06 Mar 2020 23:45:29 GMT

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/