Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change pipeline source dynamic

Status
Not open for further replies.

eri232323

Programmer
Sep 22, 2005
21
HU
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?
 
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

 
:) i did it, and it's work ! thanks! (a little late-sorry)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top