SQL Server Performance

The conditional operation failed, Error Code: -1073442717

Discussion in 'SQL Server 2005 Integration Services' started by mpavas, Sep 15, 2009.

  1. mpavas New Member

    We are facing a strange issue. We have two conditional split with condition as 'UnsignKey' == -1' and 'SignKey == -1'.
    Input to both of them is one multicast.
    The UnsignKey and SignKey data type is numeric (so we rule out the issue with data type conversion).
    When we run the package on the server we get the below error in SSIS_ERROR_LOG - The conditional operation failed, ERROR CODE: -1073442717
    We are not able to replicate this issue locally.
    Any help is appreciated.
    Background: Earlier there where two mulitcast which give input to each of the condition split transformation. To increase the performance we only use one Multicast as two Mulitcast do not make any sense. Regards, Pavas
  2. satya Moderator

Share This Page