Wednesday, November 10, 2010

How to raise Error event in SSIS?

Syntax

ComponentMetaData.FireInformation(int InformationCode,
string SubComponent,
string Description,
string HelpFile,
int HelpContext,
out bool pbFireAgain
)

FireCustomEvent
Raises a user-defined custom event in the package.

FireError
Informs the package of an error condition.

FireInformation
Provides information to the user.

FireProgress
Informs the package of the progress of the component.

FireWarning
Informs the package that the component is in a state that warrants user notification, but is not an error condition.

e.g.

bool pbFireAgain = false;

ComponentMetaData.FireInformation(0, string.Empty, "Information", string.Empty, 0, ref pbFireAgain)

No comments:

Post a Comment