#1 2012-04-22 23:11:01

ashley_ings
New member
Registered: 2012-04-22
Posts: 3

Sybase BCP out

Simple issue - I'm trying to perform a proof of concept on Talend and want to do a BCP out from Sybase (or SQL Server) .


Both of the pattens for this only seem to offer BCP "in" or BCP "update", from the drop down - where or how do I choose BCP out?

I know I've probably missed this in the training, but there is no obisouly link from Talend, Google or YouTube

Thanks very much.

Last edited by ashley_ings (2012-04-22 23:13:00)

Offline

#2 2012-04-23 04:16:33

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Sybase BCP out

Hi

Welcome to Talend Community!

I think what you want is tSybaseInput. You might link it with any other output components for migrating data.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-04-23 17:04:50

ashley_ings
New member
Registered: 2012-04-22
Posts: 3

Re: Sybase BCP out

ok -thanks for coming back to me. So we're not actually performing a BCP here. We would be perofrming a Select and then and export of the record set - right?

Seems strange that Talend supports native BCP "in", but not "out".

And why does a component called tSybaseInput actually provided a Sybase Output? shoud it not be called tSybaseOutput??? (Slightly confusing)

Thanks for you help though, all very good.

Offline

#4 2012-04-24 04:39:33

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Sybase BCP out

Hi

tSybaseInput means getting data from sybase while tSybaseOutput means saving data into sybase.

They are a little different from the concepts of BCP.
Hope this help you.

Regards,
Pedro


Only Paranoid Survive.

Offline

Board footer

Powered by FluxBB