The source object for a

mapping

task is a worksheet. Use the Microsoft Excel connection to connect to a Microsoft Excel file and read data from the Microsoft Excel file. The worksheet object is a single source in the

mapping

task.

Use a .csv file as the target object in the

mapping

task. The target in the

mapping

task is a flat file.

Map the fields of the Microsoft Excel Worksheet source to the flat file target.

The following image shows the Microsoft Excel mapping:

When you run the mapping, the Secure Agent writes the data to the flat file based on the fields you mapped in the

mapping

task.