SSRS 2008 with SSIS as Data Source problem

Question

SSRS 2008 with SSIS as Data Source problem

vrutstein

Valued Member

Points: 58
More actions
October 8, 2009 at 5:37 am

#216147

SSRS 2008 with SSIS package as a Data Source fails to process if it deployed with the following error
"Object reference not set to an instance of an object."
SSIS dosn't report any errors in the Application Log. SSRS reports the error above.
The report works fine in Visual Studio. The deployment of the report and the Data Source is ok. The package is deployed on SharePoint site as SSRS is in integrated mode.The package works also fine without SSRS.
The connection string for SSIS:
-f "E:\BNTB Solutions\Integration Services Report Center Support\Report Server Support\BDirect Wire Instruction Pending Exception.dtsx".
SSRS service and data source are working under domain user with sufficient rights.
SQL Server version is “Microsoft SQL Server 2008 (SP1) - 10.0.2734.0 (Intel X86)”
According the event log, when the package is executing from SSRS the log shows the following but it doesn't do anything. It returns an error very quickly and the log doesn’t show actual data population lines from Transformation Task like
"Message
Event Name: OnInformation
Message: "component "DataReaderDest" (843)" wrote 19 rows."
The log after the report launch is bellow. There are no "OnInformation" lines.
Date,Source,Severity,Message,Category,Event,User,Computer
10/05/2009 11:30:12,SQLISPackage100,Information,Package "BDirect Wire Instruction Pending Exception" finished successfully.,(0),1073819649,NTBNTB\RS_SQLServices,BM-VMWEBDEV-07
10/05/2009 11:30:12,SQLISPackage100,Information,Event Name: PackageEnd
Message: End of package execution.<nl/>
Operator: NTBNTB\RS_SQLServices
Source Name: BDirect Wire Instruction Pending Exception
Source ID: {55A65298-897B-4B61-9C90-C3C638D7AB2E}
Execution ID: {1371DA97-7B71-4FF1-B8CF-AF904DA276D9}
Start Time: 10/5/2009 11:30:12 AM
End Time: 10/5/2009 11:30:12 AM
Data Code: 0,(0),1074802957,NTBNTB\RS_SQLServices,BM-VMWEBDEV-07
10/05/2009 11:30:12,SQLISPackage100,Information,Event Name: PackageStart
Message: Beginning of package execution.<nl/>
Operator: NTBNTB\RS_SQLServices
Source Name: BDirect Wire Instruction Pending Exception
Source ID: {55A65298-897B-4B61-9C90-C3C638D7AB2E}
Execution ID: {1371DA97-7B71-4FF1-B8CF-AF904DA276D9}
Start Time: 10/5/2009 11:30:12 AM
End Time: 10/5/2009 11:30:12 AM
Data Code: 0,(0),1074802956,NTBNTB\RS_SQLServices,BM-VMWEBDEV-07
10/05/2009 11:30:12,SQLISPackage100,Information,Package "BDirect Wire Instruction Pending Exception" started.,(0),1073819648,NTBNTB\RS_SQLServices,BM-VMWEBDEV-07
10/05/2009 11:30:12,SQLISPackage100,Information,Event Name: OnInformation
Message: Validation phase is beginning.<nl/>
Operator: NTBNTB\RS_SQLServices
Source Name: Merge BDirect and PayPlus
Source ID: {747DE8FE-EE99-455D-9B72-E878FBB1E5F5}
Execution ID: {1371DA97-7B71-4FF1-B8CF-AF904DA276D9}
Start Time: 10/5/2009 11:30:12 AM
End Time: 10/5/2009 11:30:12 AM
Data Code: 1074016266,(0),1074802958,NTBNTB\RS_SQLServices,BM-VMWEBDEV-07
10/05/2009 11:30:12,SQLISPackage100,Information,Event Name: OnInformation
Message: Validation phase is beginning.<nl/>
Operator: NTBNTB\admrutsv
Source Name: Merge BDirect and PayPlus
Source ID: {747DE8FE-EE99-455D-9B72-E878FBB1E5F5}
Execution ID: {1371DA97-7B71-4FF1-B8CF-AF904DA276D9}
Start Time: 10/5/2009 11:30:12 AM
End Time: 10/5/2009 11:30:12 AM
Data Code: 1074016266,(0),1074802958,NTBNTB\admrutsv,BM-VMWEBDEV-07
Thank you,
Vlad

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

"Object reference not set to an instance of an object."

The above means you are using something that is disposed so where is SSIS located what account is used to run Sharepoint because in integrated mode I think it may still be dependent on the Asp.net account which needs permissions in SSIS.

Kind regards,
Gift Peddie