ETL and Data Integration tools - Modern ETL software for everyone

Good day,

I am looking for a way to pass a parameter to a transformation in Advanced ETL Enterprise to allow varibale selection from a workflow.

E.g. I want to get all invoices for 2011, next select should extract the data for 2010 etc. only.

How can I pass such a parameter to the reader?

Kind regards

Yes it is possible

There are some examples in the repository dedicated to variables

Basically all you need to do is to use script to save value into the variable
(or use set variable object)

Than in datareader use

Select * from table where field=variablename as data source

set variable=>execute transformation=>set variable=>execute transformation=>set variable=>execute transformation

ETC

Mike