SSIS task failed but package should success

Question

Question by jame4uall · Sep 29, 2012 at 07:19 PM · ssis errors

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?

0

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-10-01T08:04:36Z

Answer by aRookieBIdev · Oct 01, 2012 at 08:04 AM

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.

0 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2012-10-02T12:54:24Z

Answer by jame4uall · Oct 02, 2012 at 12:54 PM

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

0 Show 1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jame4uall · Oct 02, 2012 at 12:57 PM 0

Share

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

SSIS task failed but package should success

2 Replies

Your answer

Follow this Question

Related Questions