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 |
|
madhu_pulluru
Starting Member
5 Posts |
 Posted - 2009-01-30 : 05:12:17
|
| Hi,I have a simple DTS Package which will retrieve information from Oracle and update the tables in SqlServer 2000. When i run the package manually the package is working fine.If i run the Package through the Job it is failing with the following reason:-Executed as user: TM\hbsqlserviceprd. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_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_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.I would be greteful if you could please let us know how i can fix this issue.Many Thanks,Madhu |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-01-30 : 05:19:43
|
| A simple search reveals that you need to install the oracle client under a local admin account (or better yet, under the SQL Server Agent account) rather than your own account. If you do this, then scheduling the job will work. |
 |
|
|
madhu_pulluru
Starting Member
5 Posts |
Posted - 2009-01-30 : 05:24:54
|
quote:
Originally posted by RickD
A simple search reveals that you need to install the oracle client under a local admin account (or better yet, under the SQL Server Agent account) rather than your own account. If you do this, then scheduling the job will work.
Hi Rick,Thanks for your reply.We have installed the oracle client under a local admin account but still scheduled job is failing with the same reason.Many Thanks,Madhu |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-01-30 : 05:40:25
|
| http://www.google.co.uk/search?hl=en&q=Driver%27s+SQLAllocHandle+on+SQL_HANDLE_ENV+failed&meta=There are loads of results for this error. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 09:22:52
|
| Is SQL Server agent running on domain account? |
|
|
|
|
|
|
DTS Package-Error