Hi Sergey

I changed the package in the job step to

C:\Nicksworkspace\hf_imports\HF_Import\hf_import_test.dtsx /L

but I don't get any more information than before in the job history .

The job runs ok in the Business development studio but not in the SQL Server Job Agent.

I tried saving it in SQL server rather than running it via the file system but that didn't help

Any ideas ?





>You can use /L command line switch to enable package logging.
>
>>
>>When my dtsx package fails while running in job agent I get no details apart from
>>
>>
>>Date 20/09/2011 09:53:19
>>Log Job History (import data hf)
>>
>>Step ID 1
>>Server ICT7
>>Job Name import data hf
>>Step Name step1
>>Duration 00:00:03
>>Sql Severity 0
>>Sql Message ID 0
>>Operator Emailed
>>Operator Net sent
>>Operator Paged
>>Retries Attempted 0
>>
>>Message
>>Executed as user: ICT7\SYSTEM. The package execution failed. The step failed.
>>
>>
>>How can I get more information to appear in the log entry on the cause of failure.
>>
>>Thanks