Hi,

I'm making a datawarehouse, and I wrote DTS packages which includes several
SQL execution tasks ; each of them include many SQL commands (insert, delete
and update commands). There can be, let's say, between 10 and 40 SQL commands
in a single task.

The problem is, if one of these commands fails, the error message would be
displayed in T-SQL, but what about DTS ? It will not have the task - and
therefore the package - to stop ; which is very dangerous, of course.

Is there a solution ? Or do I have to put only one single SQL command in
each Task ? (but then, the packages would not be easy to maintain !)

Thanks for your help,


Benoit

Benoit, Please look at the following link
http://groups-beta.google.com/group/...207d255ad70 e

Allan Mitchell discusses some possible workarounds which may help you.

"Benoit" wrote: