Dataset cannot be generated error

Hot Topic

user-defined function in data flow
MySQL to SQL Server migration
Label 3X7
Inconsistent package failures
Derived Column return WRONG datatype.
Deployment Utility error
Error message "Interface not registered"
Using variables in data flow Script component
Database locking issue
Recover SDF-File

SQL Server

Do Table Value Functions eliminate parallel execution plans?
Am I missing something???
Reports with MDX queries on hierarchies loose rows on rendring
Subscription and email issues with Browser role.
SMO Restore Permissions
Convert UTC time to local time
Converting from 2005 to 2000
1:M JOIN 1:N
For each loop
CLR Trigger

Dataset cannot be generated error

When editing the data driven subscription query I SOMETIMES get the following error: The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery) Invalid object name '##XX'. The datasource is ok, authentication also, the query works... Why can't it see the temporary table


Answer this question

Dataset cannot be generated error

  • Saurabh28686

    How would I make it work with a temporary table To update the problem: when I validate the query I get the error described above however if I run the same stored procedure that is used in a query in let's say management studio and leave it open, the query in data driven subscription web interface is validated succesfully. I'm running RS2005 on a Win2003Server.

  • Master_Chief

    Did you ever find a solution I have the same problem. My data set involves concatenated SQL which causes the SP to not return the columns, but if I don't do it this way, I will be creating a monumental amount of work to have individual tables.

  • windbody

  • diDac

    I really woul appreciate any suggestions, cause it's basically messing with my report server stability...thanks
  • Dataset cannot be generated error
Answer this question