Map the query fields - Automate_Studio - Latest

Automate Studio with Studio Administrator User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
ft:locale
en-US
Product name
Automate Studio
ft:title
Automate Studio with Studio Administrator User Guide
Copyright
2026
First publish date
2018
ft:lastEdition
2026-04-01
ft:lastPublication
2026-04-01T10:39:19.933000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Automate
L4_Investment_Segment
SAP Automation
L5_Product_Group
Winshuttle Enterprise
L6_Product_Name
Automate Studio

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.