January 30, 2008 at 10:06 pm
Hi,
I'm using DTS and need to catch the error message. how to retrieve the error messages. i have used workflow as "onFailure" in the DTS. so when the error is generated during the process then, error subroutine should catch the error message.
Is there any method to get the SQL Server messages??????
January 31, 2008 at 3:11 pm
Did you try to add log file in your DTS? If so, you can trace errors in detail.
January 31, 2008 at 11:20 pm
hi
could you explain how to incorporate the log file????
February 1, 2008 at 12:57 pm
Open your DTS in design mode;
Choose Properties from Package on the menu at your top left;
It is under the logging tab.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply