Automation Import Wizard not refreshing the metadata i.e. when Excel file columns have been changed.
The Automation Script is set up to grab some Excel files and import them into a SQL Server database. The overwrite checkbox is checked.
If records are added / removed from the Excel file and run the TOAD Automation, everything works fine.
If Columns are added / removed from the Excel file, the TOAD Automation Script doesn't seem to update the metadata and completely leaves out the added or removed columns.
However, if going to the Import Script, highlight the updated file, and hit Edit, and then click Next all the way through, the metadata is updated and the file comes in correctly.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center