SSIS task failed but package should success

Dear All

I have a ssis convert task followed by few more tasks. the convert task is expected to fail. So i should get the overall package status as successful.

i tried all the options of even handler, expressions, or constraint. But didnt work. Could somebody please help me here?

asked Sep 29 '12 at 07:19 PM in Default

jame4uall
0 ● 1

(comments are locked)

2 answers:

Hi Kannan thanks I tried that even. But still the package fails. Could u plz advise any other idea.

answered Oct 02 '12 at 12:54 PM

jame4uall
0 ● 1

Hi Kannan thanks I tried that even. But still the package fails. Could u plz advise any other idea.

Oct 02 '12 at 12:57 PM jame4uall

(comments are locked)

change the MaximumErrorCount property at package level. By default the package will fail if there is any error , you can make the package to fail only after the occurance of n errors.

answered Oct 01 '12 at 08:04 AM