Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Messages Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 10:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 12:37 AM
Points: 71, Visits: 225
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??????
Post #449796
Posted Thursday, January 31, 2008 3:11 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
Did you try to add log file in your DTS? If so, you can trace errors in detail.
Post #450212
Posted Thursday, January 31, 2008 11:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 12:37 AM
Points: 71, Visits: 225
hi

could you explain how to incorporate the log file????
Post #450324
Posted Friday, February 1, 2008 12:57 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
Open your DTS in design mode;
Choose Properties from Package on the menu at your top left;
It is under the logging tab.
Post #450727
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse