Post reply

SSIS datareader destination as datasource for SSRS

  • May 17, 2007 at 1:01 pm

    #172511

    I am currently trying to use a SSIS datareader destination as a datasource in Reporting Services (RS). I have sucessfully developed the report and I am able to execute and see the results from it in the RS preview pane.  I am also able to deploy it (same server as RS development and report is on) without errors.  However, once deployed, I am unable to get the report to work in Report Manager.  I get the following error message:

    "An error has occurred during report processing. Query execution failed for data set Dynamic_POS_BO_xRef'. The package failed to execute."

    I have read everything in BOL regarding configuration of the RS Execution Account and have configured it with a domain member that has admin rights and tryed it with one that has limited rights (best practice recommendation).

    Any ideas about what else I can try?

    Thanks!

     

  • May 18, 2007 at 11:11 am

    #707539

    Two things - I would turn on the tracing (verbose, just remember to turn it back off or to less verbose when you're done) for RS and look through those logs to see if any additional messages are returned to you.  I'd also turn on package logging for the SSIS package to see if it tells you why it's not working.  My guess would be security around the service executing the package (you mentioned your RS execution account but nothing of the SSIS service account, or whether your RS account has SSIS pkg execution rights).

     

    Steve.

  • May 22, 2007 at 6:52 am

    #708043

    Turns out I was not giving the execution account with sufficient privileges...even though I thought I was.

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply