hi,
i'm having a weird problem with a scheduled job that is rather fickle about running. the job executes a DTS packaged which includes a step that utilizes an installed system DSN (on the SQL server) to a 3rd party application (Protrax). basically the DSN is used to read data in an external source and port data into a SQL database -- no big deal.
the DTS package will execute w/out error on its own, however, when the scheduled job tries to execute the package, it fails with an error stating that the driver is not active. what's strange is that sometimes the job *will* run successfully, and other times it won't.
the job is run under our SQL_SERVER_AGENT login which has rights to the import database. the DSN uses a seperate account (credentials stored in the connection object).
for what it's worth (perhaps some of you have had experience using the Axium-Protrax ODBC driver), the full returned error in the job history reads:
Error = -2147467259 (80004005)
Error string: [Axium][Axium ODBC Driver][File Library]Axium ODBC Driver not activated.
Error source: Microsoft OLE DB Provider for ODBC Drivers
any advice on this is greatly appreciated. thanks in advance!
..:: mirirom ::..
i'm having a weird problem with a scheduled job that is rather fickle about running. the job executes a DTS packaged which includes a step that utilizes an installed system DSN (on the SQL server) to a 3rd party application (Protrax). basically the DSN is used to read data in an external source and port data into a SQL database -- no big deal.
the DTS package will execute w/out error on its own, however, when the scheduled job tries to execute the package, it fails with an error stating that the driver is not active. what's strange is that sometimes the job *will* run successfully, and other times it won't.
the job is run under our SQL_SERVER_AGENT login which has rights to the import database. the DSN uses a seperate account (credentials stored in the connection object).
for what it's worth (perhaps some of you have had experience using the Axium-Protrax ODBC driver), the full returned error in the job history reads:
Error = -2147467259 (80004005)
Error string: [Axium][Axium ODBC Driver][File Library]Axium ODBC Driver not activated.
Error source: Microsoft OLE DB Provider for ODBC Drivers
any advice on this is greatly appreciated. thanks in advance!
..:: mirirom ::..