I guess I don't know how to explain what I want to do that really good.. But Sushila, it seems like you've got it!

I want to be able to...

Thanks for all!

I send you a more simplified example of my problem.

--

 -- Provocate an error inserting a wrong type value

 insert into tPrueba (COL01) values ('A')

 -- Catch the error

 if...

SORRY SUSHILA, WRONG CODE...

DECLARE @intError INT

DECLARE @Col01 varchar(100)

DECLARE @Col02 varchar(100)

DECLARE @Col03 varchar(100)

DECLARE @Col04 varchar(100)

DECLARE @Col05 varchar(100)

 insert into tArticulos(Articulo, Descripcion, UnidadBase, CosteEstandar)

 select Col02, Col03, convert(datetime, Col04), Col05

 FROM dbo.tNavisionBuffer Nav

 WHERE Col01...

Code:

Like in the first messge

Error message:

Server: Msg 241, Level 16, State 1, Line 30

Syntax error converting datetime from character string.

Comments:

I have provoked the error by...

Meaby I should have explained that what I am doing is DTS, the data in tNavisionBuffer is a mix with different tables with different fields that comes from a script. The...