Change pipeline source dynamic

[eri232323]

Hi everybody,
I have many dbf with same structure, and i would like load all datas into an sybase table.
I wouldn't like make 50 pipeline, beacuse I'm lazy
I tired to set the source dbf name but I can't...
What is the syntax for it?
I would like change the source name and the statement. but these doesn't work:
mypipe.source.name = 'ert' or mypipe.source.statement='ert'
Does enyone know it?

 

[bernds44]

to do what you like is to create one pipeline appropriate to the columns and tables you wnat to be piped. When running your application to use the pipe vith various datasources you only have to set up the source and destination transactions correctly. this means to use one pipeline against varioues datasourses you have to use different transactions not diffrent or changed pipeline objects.

transaction trans_source, trans_dest
the_pipeline_object my_pipe_object

// cerate the transactions-objects and pipelineobject

trans_source.DBMS = "...." // eg.ODBC
trans_source.DBPARM = "DNS='database1...."
...
//etc.

trans_dest.DBMS = "...." // eg.ODBC
trans_dest.DBPARM = "DNS='database2...."
...
//etc.
connect using trans_cource;
connect using trans_dest;

result_value = my_pipe_object.Start(trans_source,trans_dest,dw_pipe_errors)

disconnect using trans_cource;
disconnect using trans_dest;

// setup the transactionobjects to be used with other databases
trans_source.DBMS = "...." // eg.ODBC
trans_source.DBPARM = "DNS='database3...."
...
//etc.

trans_dest.DBMS = "...." // eg.ODBC
trans_dest.DBPARM = "DNS=database4...."
...
//etc.
connect using trans_cource;
connect using trans_dest;

result_value = my_pipe_object.Start(trans_source,trans_dest,dw_pipe_errors)

disconnect using trans_cource;
disconnect using trans_dest;


continue untill all piping is done

 

[eri232323]

i did it, and it's work ! thanks! (a little late-sorry)