Home
  •  

IS Package Failed

Microsoft.SQLServer.2005.IS_Package_Failed_5_Rule (Rule)

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

Element properties:

TargetMicrosoft.SQLServer.2005.IntegrationServices
CategoryEventCollection
EnabledTrue
Event_ID12291
Event SourceSQLISPackage
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
RemotableTrue
Alert Message
IS Package Failed
{0}
Event LogApplication
CommentMom2005ID='{A9BEA107-8C5D-4A9F-8938-3C6D0A0DECAB}';MOM2005GroupID={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.2005.IS_Package_Failed_5_Rule" Target="SQL2005Core!Microsoft.SQLServer.2005.IntegrationServices" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2005ID='{A9BEA107-8C5D-4A9F-8938-3C6D0A0DECAB}';MOM2005GroupID={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>SQLISPackage</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.2005.IS_Package_Failed_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>