Home Forums SQL Server 2005 Business Intelligence Why does a NULL aggregate warning in an SQL query causes the SSIS package to fail? RE: Why does a NULL aggregate warning in an SQL query causes the SSIS package to fail?

  • July 1, 2016 at 1:20 pm

    #1888150

    Please see this MS reply. This is a known problem with 2008 & will not be fixed. This thread gives a workaround.

    intermittent NULL failure

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams