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
Language
English
Product name
Automate Studio
Title
Automate Studio with Studio Administrator User Guide
Topic type
Administration
Overview
How Do I
Installation
First publish date
2018
ft:lastEdition
2024-03-11
ft:lastPublication
2024-03-11T17:14:05.914572

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.