Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Oracle to SQL Server DTS Error

Author  Topic  bmains Starting Member 27 Posts Posted - 2005-02-03 : 08:50:19 Hello, I'm moving data from Oracle 9i to SQL Server 2000, in a DTS package. I have a Microsoft Provider for Oracle pushing to a Microsoft Provider to SQL Server, and I'm getting the following error when the package runs. 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 Any ideas? Could this be because I need to use the Oracle-specific provider instead, or something else? In my research, I found a lot of reasons. Brian