
Error # 5 Timeout expired
I am trying to automate the update of a sql database table
from a flat dilimited file. I first want to delete the
existing records in the table, but receive the error # 5
timeout expired. The table contains about 50000 records
and if I delete it from within SQL it takes about 90
seconds to delete. How do I disable the timeout to allow
the delete to complete, or create a wait while it
completes. Before continuing on with the remaining code.
Thanks