Having a CSV file setupt to in Automation to import the file to a SQL Server table, it's slow to import only about 32,000 rows. It seems to only import 1 row at a time, instead of about 500 at a time that is set in the options.
WORKAROUND:
1. Open Toad.
2. Go to Help | About in the Toad menu bar.
3. Click on the blue link "Application Data Directory". This will bring up a directory similar to the following:
XP - C:\Documents and Settings\<User>\Application Data\Quest Software\ Toad Data Point X.X
Vista/7 - C:\Users\<User_Name>\AppData\Roaming\Quest Software\Toad Data Point X.X
(Where X.X is the version of Toad Data Point)
4. Go back one directory up from the path till you see the Toad Data Point X.X folder.
5. Close Toad.
6. Rename the folder by appending an _OLD (i.e. Toad Data Point 3.4_OLD).
7. Close the Explorer Window.
8. Launch Toad again.
9. Create the Automation script from scratch and save it and re-run the Script.
