sql server dts: I created a Local Package that drops then creates a table in SQL server, makes a connection to an Oracle database, then brings the data over. When I right click and click on Execute to execute the packge, it works fine. But when I try to schedule it, I get the following error:

Create Table [JERNBERG].[dbo].[CUM_SO_HEADERS] Step DTSRun OnFinish: Create Table [JERNBERG].[dbo].[CUM_SO_HEADERS] Step DTSRun OnStart: Copy Data from CUM_SO_HEADERS to [JERNBERG].[dbo].[CUM_SO_HEADERS] Step DTSRun OnError: Copy Data from CUM_SO_HEADERS to [JERNBERG].[dbo].[CUM_SO_HEADERS] Step, 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: Copy Data from CUM_SO_HEADERS to [JERNBERG].[dbo].[CUM_SO_HEADERS] Step D... Process Exit Code 1. The step failed.

in 99% of cases where this happens it can usually be tracked down to this
article.

http://support.microsoft.com/?kbid=269074



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
makes a connection to an Oracle database, then brings the data over. When I
right click and click on Execute to execute the packge, it works fine. But
when I try to schedule it, I get the following error:
[quoted text, click to view]
Create Table [JERNBERG].[dbo].[CUM_SO_HEADERS] Step DTSRun OnStart: Copy
Data from CUM_SO_HEADERS to [JERNBERG].[dbo].[CUM_SO_HEADERS] Step DTSRun
OnError: Copy Data from CUM_SO_HEADERS to [JERNBERG].[dbo].[CUM_SO_HEADERS]
Step, 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: Copy Data from CUM_SO_HEADERS to
[JERNBERG].[dbo].[CUM_SO_HEADERS] Step D... Process Exit Code 1. The
step failed.
[quoted text, click to view]