ODBC Bulk Update runs from command line but not from Task Scheduler
Posted on 2014-12-10
We have a batch routine that runs an ODBC bulk update to populate a SQL DB from another DB source. It works fine from the command line but when run from the Task Scheduler, we get System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode). Sometimes this can be addressed by creating an Administrator user with full rights to run the task but that user has to stay logged in. it used to work perfectly with SYSTEM as the login but has stopped. Lastly, this only happens when the ODBC database is on a different server than the SQL db to which the bulk update is being applied.