[b]How to get DTS to ignore warnings [/b]

[Nassy]

Hi

Just a simple question.

When I run scripts in a DTS the scripts will execute and then terminate as soon as there is a first error or warning. For example if I have a list of insert statements in a DTS SQL task the task is terminated as soon as one of the inserts fails. How do I stop this happening so that each line is executed in turn even if some of the inserts fail ie due to truncate errors etc?

Nassy

 

[btturner]

You may want to edit the underlying ActiveX script and use the DTSTransformStat_xxxxx variable to control the action.

Read up in BOL -- on DTSTransformStat_xxxxx