Map the query fields

The way you map the fields from your script to your data file depends on the file type that you are using:

Note:

The account that you use to write to SQL Server must have db_owner or db_ddladmin membership on the database that contains the target table.

If you are using XML forms for the data file, you do not need to map the fields.

In the Mapper, you can use the keyboard shortcuts CTRL Z (undo a command) and CTRL F (find a word or words).

In Query, you can Shift Up and Shift Down multiple rows at a time within the Mapper.