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?

  • November 5, 2012 at 4:50 am

    #1555970

    A warning is SQL will not cause the SSIS package to fail.

    I propose you create an output file for the step of the job running the SSIS package.

    Once the step has run (and failed), check this output file. you may find the actual error further down the in the file.

    it could be that you are using a value in e.g. a derived column, which could fail upon receiving a NULL value for validation et al

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”