In this example the Aggregate Sales ETL job aggregates the data from the Sales –Transactions database to the Sales – Warehouse database:
Creating an ETL Job
You can create an ETL job from the Toolbox, Browser, or Model menu.
ETL Job Properties
To view or edit an ETL job's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.