I am using SQL Server 2000.

I have developed a DTS package which has only one step of transforming the
data from flat file to sql server table.

When I run in this step in DTS editor window it just works fine.

If I schedule this package to run as job, it is failing. There is no much
error message to why it is failing.

I checked the job history and SQL server error log to read any error
messages. No luck.

Please advice.

Anil

"Anil" <AnilGowda76 (AT) hotmail (DOT) com> wrote

In the package properties turn on the log to SQL server and also set an
error file.

Probably a security problem, try reading this KB (again)-

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/kb/q269074/)


--
Darren Green
http://www.sqldts.com