How do I get a count of database records?

[Support_Duane]

To your project:

• Add an SQL task and select the database resource you want to use.
• Add a query element, and specify the following SQL statement. For example:
  select count(*) from libraryName.fileName
• Specify a variable name in the Output Variable field (e.g. "data")
• Then add a Set Variable task, found in the Miscellaneous folder.
• Enter a variable name (call it "count" for now) and then using variable notation, specify column one of the rowset defined in the Output Variable above. (e.g. ${data[1]})

Now the variable count contains the number of records the query has returned. You can use this variable to conditionally execute/skip a task or module.

The snippet below shows what the project would look like:

Code: Select all

---

    <sql resourceId="resourceName">
            <query outputVariable="data">
                      <statement>select count(*) from table</statement>
             </query>
    </sql>
    <setVariable name="count" value="${data[1]}" />