The Microsoft Access Output allows you to create a new Access database file as an output in a transformation.
The following options are available for configuring Microsoft Access output:
|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|