Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Job agent errors
Message
 
 
To
20/09/2011 05:01:07
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01524004
Message ID:
01524007
Views:
36
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform