How to get error in to sqlserver table when the package is executing in Job?

Question

Hi,

Is there way to log the error,when ever package is executing in sqlserveragent?

In brief,Lets say I have package that I have deployed to server.The pacakge is executing fine for two days,third day I got the error.So,now I want to see the error that occured and I dont want to open the package in BIDS.

Can anyone suggest the workflow for this.

Thanks

---

sudha

Answer 1

Is it for current failed package?

or you want to implement a logging system for future failures?

If this is for current troubleshooting, you can take a look at SQL Server job history, right click on sql server job and select view history, you can see error message there.

If you want to implement a logging system for future failures; then you can use LOGGING in SSIS or Event handlers to create your own custom logging.

---

http://www.rad.pasfu.com

Answer 2

Hi,

I want to know the error that may come in future purpose.So,I have to implement logging,

My issue is how to log those error in to sql table and I should able  get mail about those errors in the form of table.

---

sudha

Answer 3

so just follow Jamie's solution (second link in my previous post), to log errors in sql server table

and you can also use send mail task to send a summary or brief description of errors occurred to system administrator

---

http://www.rad.pasfu.com

Answer 4

Hi,

Thanks for your reply,here I dont want to send the mails to system adminstrator.I need the errors that occured while execution to the group mail.

Regards,

---

sudha

Answer 5

 Hi sudha,

It seems that you need the errors if the job failed? Please correct me if my understanding is wrong.

In that case, you can view the SQL Server Agent error log using SQL Server Management Studio, please see:
http://msdn.microsoft.com/en-us/library/ms191008.aspx

Thanks,
Eileen

Answer 6

Hi Eilen,

Thanks for your reply.Here I am not talking about the errors related to job failure.I want to know the errors that takes place while execution of package into sql table.

I have found the solution like configuring the log events for the package and the we can log the errors in to sql table.

Regards........

---

sudha