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:
- Microsoft Excel
- Microsoft Access
- Text file
- SQL Server
- SharePoint list
Notes:
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.