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.

Here was my fix For anyone that might experience something similar:

My ODBC driver was not setup properly. There was a DSN file that had to be
reconfigured with the proper settings.

Thanks,
Brian.

"Brian Beck" wrote: