SSIS as a data source

[JAPixley]

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

 

[xlbo]

Maybe the data reader has timed out?

Not sure whether the data source would need to be an ADO.NET as what is exposed is an ADO.NET redordset at heart... (never done this btw - have read about it but not done it)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question