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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-11 : 06:51:00
|
| sampath writes "DTS job is running fine when we are running its mannually when it comes through job its failing with folling errorExecuted as user: gepapac\sha_admin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Create Table Color_Specs_Temp Step DTSRun OnFinish: Create Table Color_Specs_Temp Step DTSRun OnStart: Copy Data from Results to Color_Specs_Temp Step DTSRun OnError: Copy Data from Results to Color_Specs_Temp 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: Error source: Help file: Help context: 0 DTSRun OnFinish: Copy Data from Results to Color_Specs_Temp Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.From logDTSRun OnFinish: Copy Data from Results to Color_Specs_Temp StepDTSRun: Package execution complete.DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: Create Table Color_Specs_Temp StepDTSRun OnFinish: Create Table Color_Specs_Temp StepDTSRun OnStart: Copy Data from Results to Color_Specs_Temp StepDTSRun OnError: Copy Data from Results to Color_Specs_Temp 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: 0Error Detail Records:Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Error source: Help file: Help context: 0DTSRun OnFinish: Copy Data from Results to Color_Specs_Temp StepDTSRun: Package execution complete.Pls help me on this this is urgent" |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-01-13 : 22:42:43
|
| If you are running from your machine it uses your authentication and Drivers...when you run it run on the server uses sql agent authentication and drivers/dlls from the server...http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.htmlThis usually happens with Oracle, when using a DSN or a misconfigured OLEDB connection string. To solve, drop-kick the DSN. Try using the OLEDB providers instead of using ODBC. First, try the Microsoft-provided OLEDB drivers: connStr = "Provider=MSDAORA.1;User ID=<userid>;" & _ "Password=<password>;Data Source=<server>.<dbname>;" If that doesn't work, download the Oracle OLEDB provider and use this connection string: connStr = "Provider=OraOLEDB.Oracle;User ID=<userid>;" & _ "Password=<password>;Server=<server>;Data Source=<dbname>;" MohammedU |
 |
|
|
|
|
|
DTS error pls help