MS SQL Server DTS - DTS - Trapping SQL errors

Author

DTS - Trapping SQL errors

vsnk

2006-03-23, 1:31 pm

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

vsnk

2006-04-05, 8:26 pm

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

"vsnk" wrote:

>
> 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

Sponsored Links