Remote Error Problem

Hi all,
I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors):

An error has occurred during report processing.

Cannot create a connection to data source 'SSIS'.

5 Anyone have any idea how to solve it? or anywhere that I can find the meaning of the 5 below the error message? Thanks in advance.
Daren
Hi all,
Sorry to post another message here. Just to touch up on my question above. I create a custom data source to SSIS in Report Server and use Windows Integrated Security. Then the error occurs.
Daren
|||Nobody knows about this error?
Daren
|||Have you looked at the logfiles?
\Program Files\Microsoft SQL Server\MSSQL.[x]\Reporting Services\LogFiles
The logfiles get really big and complex, so the best way is to stop IIS and Reporting Services, move or delete the old logfiles, restart the IIS and Reporting Services, run your report and look into the logfiles. Usually you can find a bit more verbose Errormessages there.

|||Hi BenniG,
Sorry I took so long to reply, I managed to browse through the log and found the following content:
w3wp!processing!7!5/18/2006-09:27:24:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
at MgdParser.CreatePackage(Boolean bNeutral, Boolean bRemote)
at Microsoft.SqlServer.Dts.DtsClient.DtsConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionWrapper.Open()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
End of inner exception stack trace
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: Data source 'SSIS': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: An exception has occurred in data source 'SSIS'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
w3wp!processing!7!5/18/2006-09:27:25:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!7!5/18/2006-09:27:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
End of inner exception stack trace
w3wp!webserver!7!05/18/2006-09:27:25:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'SSIS'. > System.ApplicationException: 5
But I still do not get what does System.ApplicationException: 5 means. Do you know anywhere that I can find the description of error #5 stated in the log or report server?
Daren
|||Can you post these messages to the SSIS forum? You should be able to get a better response there.|||ok. Thanks Tudor.
Daren