OLEDB Select

This task will execute a Query and return a data set back in XML format using the Root and Row settings for the XML.

Settings

Output File

Required
Name of the XML file to output results to.

Root

Required
Name of the XML root e.g. Customers.

Row

Required
Name of the XML row e.g. Customer.

Parameter Field

Optional
Parameter to use when building the output file.

Parameter Input File

Optional
The file containing the parameters that will be replaced in the query.

Parameter Output File

Optional
The file that will contain the parameters created from the query.

Query

Required
The SQL query to be executed, see below for an example. You can use the Using the Query Designer to build the query visually.

Connection

Required
The OLEDB Connection to use. See the Connecting to an OLEDB Database article if you require more information on how to create/manage connections.

Zynk Settings

See Common Task Settings

Examples

You can find an example of how to use this task in the Using the OLEDB Connector tutorial.

Sample SQL query:

SELECT CustomerAccountNumber, CustomerAccountName, AccountBalance, CreditLimit FROM SLCustomerAccount

Sample output file if you do not specify any values for the Root and Row XML field names. The output defaults to using "Rows" for the root and "Row" for each row in the result set.

<?xml version="1.0" standalone="yes"?>
<Rows>
    <Row CustomerAccountNumber="INT01" CustomerAccountName="Merchant Solutions plc" AccountBalance="0.00" CreditLimit="10000.00"  />
    <Row CustomerAccountNumber="INT02" CustomerAccountName="AG Electronics Ltd"  AccountBalance="0.00" CreditLimit="10000.00"  />
    <Row CustomerAccountNumber="INTE001" CustomerAccountName="Internetware Limited" AccountBalance="0.00" CreditLimit="0.00"  />
</Rows>

Sample output file when the Root and Row properties have been as "Customers" and "Customer" to give us more specific XML.

<?xml version="1.0" standalone="yes"?>
<Customers>
    <Customer CustomerAccountNumber="INT01" CustomerAccountName="Merchant Solutions plc" AccountBalance="0.00" CreditLimit="10000.00"  />
    <Customer CustomerAccountNumber="INT02" CustomerAccountName="AG Electronics Ltd"  AccountBalance="0.00" CreditLimit="10000.00"  />
    <Customer CustomerAccountNumber="INTE001" CustomerAccountName="Internetware Limited" AccountBalance="0.00" CreditLimit="0.00"  />
</Customers>