When my DTS package ran I got the following information:

SQL Log error:

Executed as user: cwopa\pwsrvsql001. ...ting... DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:
DTSStep_DTSBulkInsertTask_1 DTSRun OnFinish:
DTSStep_DTSBulkInsertTask_1 DTSRun OnStart:
DTSStep_DTSBulkInsertTask_3 DTSRun OnFinish:
DTSStep_DTSBulkInsertTask_3 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
Error string: Error Code: 0 Error Source= Microsoft JET Database
Engine Error Description: Syntax error in string in query expression
'''. Error on Line 265 Error source: Microsoft Data
Transformation Services (DTS) Package He. The step failed.


Package log errors:

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Error Code: 0
Error Source= Microsoft JET Database Engine
Error Description: Syntax error in string in query expression '''.

Error on Line 265
(Microsoft JET Database Engine (80040e14): Syntax error in string in
query expression '''.)
Step Error code: 800403FE
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4500

It reads to me like there is a syntax error in my query... Only one
problem, this batch has been running fine for two years and the code
has not changed. Could it be the text file I am importing? Basically
my run takes a text file of data, imports it into SQL Server and then
breaks it down into smaller Access databases. The error comes when it
is trying to put the data into Access. It just started happening. The
error happened once before and it cleared itself out after running a
couple of times with no changes on my end, the only difference was the
input text file changed. PLEASE ANY HELP WOULD BE GREATLY
APPRECIATED!!! My datatbase team can help me at all...

Not a lot of information but I'll give it a shot: check if there are
double-qoutes in your import text file. If SQL Server imports these into a
table, then during export to Access it could give trouble. Eg

sql
select * from table where name = 'test'

access
select * from table where name = "test"

Access uses " in stead of '. Seeing that you get an error like ''' or "',
look at quotes. Also look for single-quotes in the source text file. Try to
replace both in the source text file by and empty string and test if the