DTS ODBC Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS ODBC Error

Executed as user: CACIsvcPM2SQL. DTSRun: Loading… DTSRun: Executing… DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed. SQL Server and SQL Server Agent both are running under svcPM2SQL account. svcPM2SQL account is sysadmin for SQL Server. I am able to establish connection to Oracle via SQL Plus. I dont have any ODBC source defined to the databases. I am providing Oracle username, password and server within DTS and using Mircosoft ODBC Driver for Oracle. what could be wrong?
http://www.aspfaq.com/show.asp?id=2009 to fix the issue. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>