question

jame4uall avatar image
jame4uall asked

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?
ssiserrors
10 |1200

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

aRookieBIdev avatar image
aRookieBIdev answered
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.
10 |1200

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

jame4uall avatar image
jame4uall answered
Hi Kannan thanks I tried that even. But still the package fails. Could u plz advise any other idea.
1 comment
10 |1200

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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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