Hi, I have below version of SQL Server Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Is it possible to have Subscriptions that sends out reports to emails at scheduled timings?? Or is this option available only in Enterprise Editions? Please advice. Thanks.

Have a read of this great blog by Greg Low http://sqlblog.com/blogs/greg_low/archive/2008/08/13/data-driven-subscriptions-in-sql-server-2005-standard-edition.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Have a read of this great blog by Greg Low http://sqlblog.com/blogs/greg_low/archive/2008/08/13/data-driven-subscriptions-in-sql-server-2005-standard-edition.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker Sorry, I forgot to say that you can't do what you want in SSRS Standard Edition :-)Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi Standars Edition will Not Provide Subscription Option. But you can use Webservice Task in SSIS or use Script Task . Code 'Declaration <SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/CreateDataDrivenSubscription", RequestNamespace := "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", _ ResponseNamespace := "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", _ Use := SoapBindingUse.Literal, ParameterStyle := SoapParameterStyle.Wrapped)> _ <SoapHeaderAttribute("BatchHeaderValue")> _ <SoapHeaderAttribute("ServerInfoHeaderValue", Direction := SoapHeaderDirection.Out)> _ Public Function CreateDataDrivenSubscription ( _ Report As String, _ ExtensionSettings As ExtensionSettings, _ DataRetrievalPlan As DataRetrievalPlan, _ Description As String, _ EventType As String, _ MatchData As String, _ Parameters As ParameterValueOrFieldReference() _ ) As String 'Usage Dim instance As ReportingService2005 Dim Report As String Dim ExtensionSettings As ExtensionSettings Dim DataRetrievalPlan As DataRetrievalPlan Dim Description As String Dim EventType As String Dim MatchData As String Dim Parameters As ParameterValueOrFieldReference() Dim returnValue As String returnValue = instance.CreateDataDrivenSubscription(Report, _ ExtensionSettings, DataRetrievalPlan, _ Description, EventType, MatchData, _ Parameters http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.createdatadrivensubscription.aspx Mark it as Answered if found useful.Rakesh M J

Hi RubSay, Reporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups. To distribute or receive a report by e-mail, we define either a standard subscription or a data-driven subscription. As Jeff and Rakesh posted above, the data-driven subscriptions are not supported in the Standard edition or SQL Server Express with Advanced Services. However, we can define a standard subscription. Before we use standard subscription, we should configure the Report Server E-mail. For more information, please refer to the article below: How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration) Regards, Bin Long