DTS Windows Scheduling error only when logged off
- From: "Brian Beck" <BrianBeck@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 2 Aug 2005 14:05:02 -0700
Ok,
I am using Windows Server 2003, Sql Server 2000 version 8.00.760
I have a batch file that runs a DTS package using DTSrun as follows :
DTSRUN /S "(local)" /E /N "EVA mod_CR_CYR_INSTR" /L "C:\EVA DTSPackage
Scheduling\DTSScheduleLog.txt" /W "-1"
When I run this batch file or schedule it in Windows Scheduler logged in to
the server it runs fine. When I schedule it in Windows Scheduler (and I put
the same account I was logged in as in the Run as textbox) and log out ,
the DTS package errors. The package drops the table in my database and then
creates the table in my database, but when it goes to copy data from my ODBC
source, it fails. This only happens when I am LOGGED OUT of the server. The
ODBC is setup as a system DSN. Here is the error I get in my errorlog:
*******************
Step 'Copy Data from CR_CYR_INSTR to [EVASourcedb].[dbo].[CR_CYR_INSTR]
Step' failed
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:CCIINIT FAILURE: CCI error file not found for text in
SQLDriverConnect
(Microsoft OLE DB Provider for ODBC Drivers (80004005): Error in DBOpen
connection processing in SQLDriverConnect)
(Microsoft OLE DB Provider for ODBC Drivers (80004005): CCIINIT FAILURE: CCI
error file not found for text
in DBOpen) (Microsoft OLE DB Provider for ODBC Drivers (80004005): error
during OPENP in DBOpen)
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
Step Execution Started: 8/2/2005 3:51:00 PM
Step Execution Completed: 8/2/2005 3:51:01 PM
Total Step Execution Time: 1.109 seconds
Progress count in Step: 0
**************
Any help would be GREATLY appreciated.
Brian.
.
- Follow-Ups:
- RE: DTS Windows Scheduling error only when logged off
- From: Brian Beck
- RE: DTS Windows Scheduling error only when logged off
- Prev by Date: Re: Disable DTS 2005 tasks dynamically at run time.
- Next by Date: Re: Not enough storage is available to complete this operation
- Previous by thread: Best way to integrate all filenames in a directory with SQL Recordset?
- Next by thread: RE: DTS Windows Scheduling error only when logged off
- Index(es):