ETL and Data Integration tools - Modern ETL software for everyone

Is to possible to use Advanced ETL processor enterpise to:

let it run a sql query, then export the output to a xml / csv document and then mail it to a user?

We are trying to build this using ETL processor, but we can\'t find the options to do this...

Thanks in advance.

Kind regards,
Menno

Hello

Yes, it is possible to use Advanced ETL processor Enterprise to export data and send emails.
Are you having any specific problems?

John

Hello John,


We are running the following query:


select * from current_orders

Normaly this will give a couple of records output, wich we want to export to a csv file and then mail it.
The question is how should we do this in ETL processor? Using a transformation?

Menno

There is no need to use transformation here

You can just use packages

Mike