Create a MySQL SELECT query to select the data you want to output to CSV. Specify the output file and the four CSV options: "FIELDS TERMINATED BY" specifies the character used between fields ...

See Viewing the SQL Code, Running the Query, and Refining the Output for more information. To run your report immediately, select Submit from the SQL Editor window's Run menu. Your output is displayed ...

Double-click the Toolbox, locate the data flow task icon and drag it to the control flow window to create a data ... under Custom Properties. Type the MySQL query to extract the data you need.