Access Output

Description

The Microsoft Access Output allows you to create a new Access database file as an output in a transformation.

Options

The following options are available for configuring Microsoft Access output:

Option

Description

Step name

Name of the step; this name has to be unique in a single transformation

The database filename

The file name of the database file to which you are connecting

Create database

Enable to generate a new Access database file

Target table

Specifies the table to which you want to output data

Create table

Enable to create a new table in the Access database

Commit size

Defines the commit size when outputting data