Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alex_pixley
Starting Member
1 Post |
 Posted - 2011-06-09 : 15:22:18
|
| I'm using SQL Server 2005 and am trying to create an SSRS report that uses an SSIS package as a data source. So far, I've:1. Edited the RSReportDesigner.config file.2. Created a fairly simple SSIS package that uses a DataReader Destination.3. Created a shared data source of Type: SSIS and an appropriate connection string (-f "C:\Documents and Settings\apixley\My Documents\Visual Studio 2005\Projects\JobReportSource\JobReportSource.dtsx" (If I use any other configuration, I get an error that a connection cannot be made.)).4. Used the name of the DataReader Destination as the query string.The report seems to see the SSIS package, but I cannot see any Available fields. When I try to view the report, I get this error:Warning 1 Deserialization failed: The element 'TableCells' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has incomplete content. List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:TableCell'. Line 38, position 16. 38 0 What am I missing?Thanks,Alex |
|
|
|
|
|
SSIS as a data source