SSRS 2008 with SSIS as Data Source problem

  • 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

  • "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

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

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