The input data for a Bulk API procedure can be in the form of a CSV file. This can easily be created by DataMigrator data flow.

The column names must match the Salesforce field names of the object to be loaded. This can be done in the SQL Column Select by specifying an Alias.

The target properties should specify a target adapter of Delimited Flat File, delimiter of comma and header set to Yes. If data values could include commas, use an Enclosure of double quote (“).

Date values must be in the format 2012-05-25

Below is an example of an input file for the Opportunity object with a few fields:

Name,StageName,CloseDate
iWay Software,test,2012-05-25
Level 5,test,2012-05-25
Information Builders,test,2012-05-25
InfoBuild,test,2012-05-25