Table Exists

Description

You can use the Table Exists step to verify if a certain table exists in a database.  The result of this step is a boolean flag field.

Options

Option

Description

Step name

The name of the step. This name has to be unique in a single transformation.

Connection

The database connection to use

Schema name

The schema of the table to look for

Table name field

The name of the field that will contain the database table name to look for.

Result fieldname

The name of the field that will contain the boolean result flag in the output of this step.