General information
Forum:
Microsoft SQL Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only