Import Script

Import script was brought into Advanced ETL Processor to make it compatible with Visual Importer ETL. Unlike Transformation it only offers data Import functionality. Loading data using Import Script is slightly faster than doing the same using Transformation.

For all new projects, we recommend using Transformation because it offers much more functionality.

Getting Started with import Scripts

• Importing Data
• Import Process

HowTo

• Load data from a Flat File(s)
• Load data from an ODBC Data Source
• Load data from Excel/Access/Dbf File(s)
• How To Clear Mapping
• Perform Calculations
• Filter data
• Working with Date fields
• Update or Delete Records
• Using Database Specific functions