Configure a Data Access activity

  1. Add a Data Access activity to the map. See Add an activity.
  2. On the Extended Properties page, click the Configuration tab.
  3. To specify the database connection string to hold the details of the relational database, consume the connection string in the Connection String box.
    Note
  4. Click Configure to create a query. See Create a DB query.

    The generated query appears in the Query box and a list of result parameters based on the query appears under Output Parameters.

  5. Map all the output parameters with the relevant variables.
    Note ODBC and OLEDB do not support xml data type.
  6. Map the ResultSet and the RowsReturned output parameters with the dynamic complex and long variables respectively as follows:
    1. Create a dynamic complex, and a long process variable. See Create process variables.
    2. Consume the complex variable in the Value box of the ResultSet parameter.
    3. Consume the long variable in the Value box of the RowsReturned parameter.
  7. Click Save.