Home
  •  

MSSQL Integration Services on Windows: Integration Service Package Failed

Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_Rule (Rule)

A package failed during execution.

Knowledge Base article:

Summary

A package failed during execution.

Causes

Failure may have occurred for a variety of reasons.

Resolutions

Investigate the logs that were generated by the execution instance of the package. If the package was not configured to implement logging, it is recommended that you add logging.

External

For more information, see the Docs Online topics: "Integration Services Log Providers" and "Implementing Logging in Packages".

Overridable Parameters

Name

Description

Default Value

Allow Proxying

Specifies whether the module should collect events that do not originate from the computer that is specified in the ComputerName parameter.

No

Enabled

Enables or disables the workflow.

Yes

Priority

Defines Alert Priority.

1

Severity

Defines Alert Severity.

2

Element properties:

TargetMicrosoft.SQLServer.IS.Windows.LocalInstance
CategoryEventCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
RemotableTrue
Alert Message
MSSQL Integration Services on Windows: Integration Service Package Failed
Event ID: {0}. Package "{1}" failed.
CommentMom2017ID='{A9BEA107-8C5D-4A9F-8938-3C6D0A0DECAB}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.IS.Windows.EventProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_Rule" Target="Microsoft.SQLServer.IS.Windows.LocalInstance" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2017ID='{A9BEA107-8C5D-4A9F-8938-3C6D0A0DECAB}';MOM2017GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.IS.Windows.EventProvider">

      <ComputerName>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/NetBiosComputerName$</ComputerName>

      <LogName>Application</LogName>

      <AllowProxying>false</AllowProxying>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>12291</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>SQLISPackage$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MajorVersion$0</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>2</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.IS.Windows.IS_Package_Failed_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDisplayNumber$</AlertParameter1>

        <AlertParameter2>$Data/Params/Param[1]$</AlertParameter2>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>