DTS - Trapping SQL errors

#1

I am panning to write a DTS (SQLServer 2000) package whcih alters the table
and output any error messages when failed.

I have created Execute SQL Task in which I have wrote the following command.

Alter table Employee ADD EmpStatus char(4) DEFAULT A not null;

I have created a work flow to write the error message to a text file. But I
am having trouble to trap the error message prduced by the Alter statement
(like "column names in each table must be unique. Column name specified int
the table more than once").

Any help will be appreciated.

Thanks

#2

Am I thinking wrong or nobody knows answer to this question?

"vsnk" wrote:

Quote:

I am panning to write a DTS (SQLServer 2000) package whcih alters the table
and output any error messages when failed.

I have created Execute SQL Task in which I have wrote the following command.

Alter table Employee ADD EmpStatus char(4) DEFAULT A not null;

I have created a work flow to write the error message to a text file. But I
am having trouble to trap the error message prduced by the Alter statement
(like "column names in each table must be unique. Column name specified int
the table more than once").

Any help will be appreciated.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS - Trapping SQL errors

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS - Trapping SQL errors - 03-23-2006 , 01:15 PM

RE: DTS - Trapping SQL errors - 04-05-2006 , 02:25 PM