Amy
2004-08-31 19:17:28 UTC
I have a job transforming a foxpro database into a sql
server database. When I run it on our production SQL
Server, it fails; when we run it on a user's local SQL
Server, it runs with no errors. The job FTP's a file,
unzips it, then executes a transformation task. We've
had problems with the agent's user not having access to
the Foxpro drivers (which I still don't think I've
resolved), but the weird thing is the job actually starts
running now, and fails near the end. So it obviously is
at least finding the Foxpro drivers now, because we can
see the table is getting loaded. But the load fails
before all of the rows are loaded, and this is the only
error message I get in the "details" section of the
history:
Executed as user: GLOBUSANDCOSMOS\SQL. ...p -d
y:\tech\cmsdataWarning: TZ environment variable not
found, cannot use UTC times!! Archive:
y:/tech/glb_exp.zip inflating:
y:/tech/cmsdata/EXPORT.DBF inflating:
y:/tech/cmsdata/notes.dbf inflating:
y:/tech/cmsdata/notes.fpt C:\WINDOWS\system32>del
y:\tech\glb_exp.zipDTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1
DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun OnStart:
DTSStep_DTSCreateProcessTask_1 DTSRun OnFinish:
DTSStep_DTSCreateProcessTask_1 DTSRun OnStart:
DTSStep_DTSCreateProcessTask_2 DTSRun OnFinish:
DTSStep_DTSCreateProcessTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_3 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_3; 1000 Rows have been
transformed or copied... Process Exit Code 1. The step
failed.
Does anyone know where I can get a more detailed
description of what is happening? Also, what kind of
security do I need to set up to make sure the SQL Server
Agent user has access to them? Thanks.
Amy
server database. When I run it on our production SQL
Server, it fails; when we run it on a user's local SQL
Server, it runs with no errors. The job FTP's a file,
unzips it, then executes a transformation task. We've
had problems with the agent's user not having access to
the Foxpro drivers (which I still don't think I've
resolved), but the weird thing is the job actually starts
running now, and fails near the end. So it obviously is
at least finding the Foxpro drivers now, because we can
see the table is getting loaded. But the load fails
before all of the rows are loaded, and this is the only
error message I get in the "details" section of the
history:
Executed as user: GLOBUSANDCOSMOS\SQL. ...p -d
y:\tech\cmsdataWarning: TZ environment variable not
found, cannot use UTC times!! Archive:
y:/tech/glb_exp.zip inflating:
y:/tech/cmsdata/EXPORT.DBF inflating:
y:/tech/cmsdata/notes.dbf inflating:
y:/tech/cmsdata/notes.fpt C:\WINDOWS\system32>del
y:\tech\glb_exp.zipDTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1
DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun OnStart:
DTSStep_DTSCreateProcessTask_1 DTSRun OnFinish:
DTSStep_DTSCreateProcessTask_1 DTSRun OnStart:
DTSStep_DTSCreateProcessTask_2 DTSRun OnFinish:
DTSStep_DTSCreateProcessTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_3 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_3; 1000 Rows have been
transformed or copied... Process Exit Code 1. The step
failed.
Does anyone know where I can get a more detailed
description of what is happening? Also, what kind of
security do I need to set up to make sure the SQL Server
Agent user has access to them? Thanks.
Amy