Automating ODBC import using the Import Records script step
Because accessing ODBC data sources is a task you might repeat frequently, you can create a script with the Import Records script step that automates ODBC import. Some script step options behave differently than when used with other file formats.
The Specify data source option stores:
 •
 •
 •
the SQL query to be executed against the data source
For more information, see Import Records script step.
When you choose an ODBC data source in the Import Records script step, the Specify ODBC SQL Query dialog box opens. You can do any of the following:
 •
 •
 •
Notes
 •
To save the user name and password, select Save user name and password in the ODBC Enter Password dialog box.
 •
The Perform without dialog option hides all dialog boxes during an ODBC import.
 •
The Specify import order option stores the field order in the Import Field Mapping dialog box, similar to other scripted imports.
 •
The Set Error Capture script step suppresses ODBC alerts.
 •
 •
 •
 •
 •
 •