November 30, 2006 at 4:20 am
Hi all,
I am calling a MySQL Stored Proc from a DTS Execute SQL task and I need to get the error description on a failure.
When I run the DTS manually and the step fails I get an error description if I double click on the step in the DTS run window, but when I look in the msdb..sysdtspackagelog the errordescription is NULL (although the error is definately there).
Any idea how I can get the description I see in the run window?
Ta,
Giles
(Marvin)
November 30, 2006 at 10:50 am
Enable logging for the package by going to the "Logging" tab of Package Properties in DTS Designer and checking "Log package execution to SQL Server". You can also designate a log file if you want to store messages outside of SQL Server.
Greg
Greg
December 1, 2006 at 2:26 am
Thanks but I don`t think you understood.
Logging is enabled, otherwise I would not get any rows in the log table (as I said, the error is there, but the description is NULL).
What I need to know is how to get at the error description, which the DTS clearly gets passed to it as it shows up in the run window, but which does not seem to get entered into the table.
Giles
(Marvin)
December 1, 2006 at 10:49 am
Are you looking at the table by opening it in Enterprise Manager? I've noticed that errordescription isn't displayed there. I can see it if I query the table in QA. You can also query sysdtssteplog for errors.
Greg
Greg
January 15, 2007 at 9:06 am
I am having the same issue (even when I query the tables).
Did you ever resolve this issue?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply