SQL

Most of the data delivered by data providers is defined by using SQL stored in the Query property. Sybase ETL Small Business Edition supports a modified set of the SQL-92 standard.

If you do not want to get into the details of SQL-92, you can use the built-in Query Designer to draw the query and have the SQL generated for you. If you want to write SQL manually, or copy SQL from existing projects, you can manually specify your SQL for the Query property.