In SQL Server 2005, I'm struggling with defining a connection between Reporting Services and an Integration Services package that writes to a Data Reader destination. Any help greatly appreciated. This is a simple "hello world" type app just to shake out the basic connectivity issues. In the dvel environment I'm working in, Reporting Services and Integrations Services are running on the same server.
I've read various threads and also read the Books Online "Defining Report Datasets for Package Data from SQL Server Integration Services" article, but obviously am still in need of a few more details. The unattended execution account has been configured and the SSIS data processing extension. In RSReportDesginer.config, I un-commented out the two lines referring to SSIS as a source type. I moved the package I developed (Baseball_Test_Package.dtsx) to the root level of my local c drive, and opened up Reporting Services. I clicked on New Report and in the Wizard, at the Select the Data Source screen, specified settings with New DataSource Name: Datasource1, Type:SSIS and Connection String: -f c:\Baseball_Test_Package.dtsx. Got the below message when I clicked Next:
A connection cannot be made to the database.
Set and test the connection string.
The package failed to validate.
Is that error referring to the specification in the Connection String box on this dialogue, or does the problem lay elsewhere? Thank you in advance for any suggestions.