Home
  •  

MSSQL 2016: IS Package Failed

Microsoft.SQLServer.2016.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 Books Online topics: "Integration Services Log Providers

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

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Priority

Defines Alert Priority.

1

Severity

Defines Alert Severity.

2

Element properties:

TargetMicrosoft.SQLServer.2016.IntegrationServices.Instance
CategoryEventCollection
EnabledTrue
Event_ID12291
Event SourceSQLISPackage130
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
RemotableTrue
Alert Message
MSSQL 2016: IS Package Failed
{0}
Event LogApplication
CommentMom2016ID='{A9BEA107-8C5D-4A9F-8938-3C6D0A0DECAB}';MOM2016GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID Module Type TypeId RunAs 
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.2016.IS_Package_Failed_5_Rule" Target="SQL2016IS!Microsoft.SQLServer.2016.IntegrationServices.Instance" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2016ID='{A9BEA107-8C5D-4A9F-8938-3C6D0A0DECAB}';MOM2016GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <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>SQLISPackage130</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>1</Priority>

      <Severity>2</Severity>

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

      <AlertParameters>

        <AlertParameter1>Event ID: $Data/EventDisplayNumber$. $Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>