Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp Trigger an Email of an SSRS Report from an SSIS Package RE: Trigger an Email of an SSRS Report from an SSIS Package

  • April 14, 2014 at 10:10 am

    #1705820

    ajv849 (4/14/2014)

    Thank you .

    I do not have the accessiblity permission to the native sql proc.. So the only way left for me is to write a .net app to trigger the subscriptions.

    But I want to know what would be the best way of achieving this . SSIS trigger of a proc or use webservice in a .net app.

    Please let me know your thoughts.

    Regards

    >>>>>>>>>>

    AJV

    I don't know what you mean by not having accessibility to ReportServer.ado.AddEvent.

    You have to execute that procedure from a SQL statement. The .NET SqlCommand class would do it.

    I found this link that might help:

    Executing Database Commands Asynchronously with ADO.NET 2.0