Error Messages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Error Messages

Error Messages

Rate Topic

Display Mode

Topic Options

Author

Message

Ananth-431739

Posted Wednesday, January 30, 2008 10:06 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, August 08, 2012 8:50 AM
Points: 71, Visits: 213

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

SQL ORACLE

Posted Thursday, January 31, 2008 3:11 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 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

Ananth-431739

Posted Thursday, January 31, 2008 11:20 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, August 08, 2012 8:50 AM
Points: 71, Visits: 213

hi

could you explain how to incorporate the log file????

Post #450324

SQL ORACLE

Posted Friday, February 01, 2008 12:57 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 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 »

Permissions