August 4, 2015 at 10:26 pm
Hi ,
I have created simple package loading data from source to destination.
in BIDS working fine, but when i created job through sql server agent job I am getting below error.
Error:-
The Job was invoked by User . The last step to run was step SQL AGENT JOB
attached the screenshot for reference.
Kindly help me to get solution of above issue.
Regards,
Vipin Jha
August 5, 2015 at 5:13 am
There is likely a more detailed error description if you click it open.
Example
Executed as user: X\Y.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.5592.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 17:03:39 Package execution on IS Server failed.
Execution ID: 218685, Execution Status:4.
To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report
Started: 17:03:39 Finished: 17:03:46 Elapsed: 6.828 seconds. The package execution failed. The step failed.
In that case follow the instructions and run the all excecutions report on the ssisdb catalog
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply