Upfront - I'm not sure if this question belongs with this forum or another more specific to SQL Server Agent.
I have a package running on Windows 2003 (64-bit) attempting to pull data from a Teradata server using its 32-bit driver. The package runs as expected within BIDS and when called from a BAT file run from the command prompt using the 32-bit version
The package fails with the following error when I attempt to run it using the same *.BAT file (which succeeds from a command prompt) or when specifying the DTEXEC command directly in an operating system job step. Any insight, suggestions, or workarounds
would be helpful.
Executed as user: <<<userName removed>>>. ...\dtexec.exe /SQL \HRD_ODS\TheW_Connection_Test /SERVER CRPRDNMSQR2 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EMicrosoft (R) SQL Server Execute Package Utility Version
9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:47:59 AM Error: 2011-01-25 11:48:01.26 Code: 0xC0047062 Source: Data Flow Task
DataReader Source  Description: System.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could not be loaded due to system error 126 (Teradata)
. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle
hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection
outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConn... Process Exit Code 1. The step failed.