Is there a method to use the Data Import Wizard by making usage of saved import settings for importing several CSV files into SQL Server 2005 tables, for example, source file, field mappings and destination table? Ideally, a file to be opened which loads a previously saved set of configurations.
Enhancement request has been submitted to Development for consideration in a future release of Toad for SQL Server.
This feature is scheduled to be included in version 4.0. The Import Wizard will have the "Save Template" option which will save Import settings to a designated template file. In addition to this option, the new Import menu will have "Open Import Template" and "Execute Import Template" options.