Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: SSRS Export whole underlying dataset to excel.

    Hi Adam

    Have you considered going the other way?

    SSAS OLAP cube with a custom action which allows users to run a formatted SSRS report?

    That way users can interrogate data and if...

    [font="Arial Narrow"]MCITP Sql Server 2008: Business Intelligence. 4 Years +
    Jason Vollaire[/font]
  • RE: If count of records in query >0, proceed, else stop SSIS task and email

    No problem, glad it was what you were looking for.:cool:

    [font="Arial Narrow"]MCITP Sql Server 2008: Business Intelligence. 4 Years +
    Jason Vollaire[/font]
  • RE: If count of records in query >0, proceed, else stop SSIS task and email

    Hi There

    Simplest for me would be the following:

    Create a variable and populate the result to that variable

    a) Right click on your control flow surface and select "Variables"

    b) Create...

    [font="Arial Narrow"]MCITP Sql Server 2008: Business Intelligence. 4 Years +
    Jason Vollaire[/font]
  • RE: Event Handlers. Onerror Vs OnFailure

    Hi There

    From my understanding these event handlers serve different purposes:

    a) OnError: This error handler handles errors that occur across the package and will be raised for each error that occurs.

    b)...

    [font="Arial Narrow"]MCITP Sql Server 2008: Business Intelligence. 4 Years +
    Jason Vollaire[/font]

Viewing 4 posts - 1 through 4 (of 4 total)