DTS Package fails when Scheduled
- From: Chuck G. <Chuck G.@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 29 Jan 2007 06:27:00 -0800
I am running SQL 2000. I have a DTS that imports an Access database from a
remote source into my SQL server. When I excecute the DTS manually it runs
perfectly, but when run as a Scheduled job I get the following error:
Executed as user: SQLSERVER\SYSTEM. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: Copy Data from Results to Results Step
DTSRun OnError: Copy Data from Results to Results Step, Error = -2147467259
(80004005) Error string: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
Obviously the ODBC connection is not at fault since the package ruins fine
when not scheduled. I am looking at permissions, as the DTS scheduled job
password is different from the Access ODBC password. It doesn't make a lot
of sense that the job password would be passed onto the ODBC, but I am at a
loss.
Any ideas?
.
- Follow-Ups:
- RE: DTS Package fails when Scheduled
- From: Servando Canales
- RE: DTS Package fails when Scheduled
- Prev by Date: DTS run on remote server consumes all CPU on local server
- Next by Date: Re: Variable - Capture Running Count of Errors
- Previous by thread: DTS run on remote server consumes all CPU on local server
- Next by thread: RE: DTS Package fails when Scheduled
- Index(es):
Relevant Pages
|
