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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

2 Answers

·
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
Toggle Comment visibility. Current Visibility: Viewable by all users

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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 ·
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.