tag:blogger.com,1999:blog-11909584.post7373511107606186361..comments2024-03-26T03:58:05.993-07:00Comments on Siddharth Mehta's Blog: SSIS and SSRS Integration for generating reports and sourcing dataSiddharth Mehtahttp://www.blogger.com/profile/02870225483799389119noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-11909584.post-33807863833336224142015-11-28T18:04:15.456-08:002015-11-28T18:04:15.456-08:00HI Siddath,
I read your article "Bulk Report ...HI Siddath,<br />I read your article "Bulk Report Generation using SSIS and SSRS 2008 R2" on MSDN white papers.It was very helpful and I was able to implement for many of my automated reports that ran with parameters. But now we have upgraded our systems to SQL Server 2014 and we need to do the same. Could you please let me know if you have details on how to implement bulk report generation in 2014. If so, it would be great if you could share it.<br />Thanks,<br />VidhyaAnonymoushttps://www.blogger.com/profile/05860341806553734113noreply@blogger.comtag:blogger.com,1999:blog-11909584.post-46011375241857227092013-05-25T04:00:38.030-07:002013-05-25T04:00:38.030-07:00HI Siddath,
I read your article "Bulk Report ...HI Siddath,<br />I read your article "Bulk Report Generation using SSIS and SSRS 2008 R2" on MSDN white papers.And it sound very good. I struggled to do implement the same as you explained and finally couldn't solve :(<br />Is it possible to share the report and SSIS package what you have done in the article.It would be great if you share,please mail maruthi.vm@gmail.com. Thanks in advance :)<br /><br />Regards,<br />MaruthiMaruthi Siva Prasadhttps://www.blogger.com/profile/12534819546372960746noreply@blogger.comtag:blogger.com,1999:blog-11909584.post-29580578392704808192012-07-17T10:28:19.877-07:002012-07-17T10:28:19.877-07:00Good article...Good article...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11909584.post-92037887964438192372011-05-06T11:09:53.704-07:002011-05-06T11:09:53.704-07:00Reports are meant to view data and not edit data i...Reports are meant to view data and not edit data in data sources. Applications are aimed for the same purpose. In my views, you cannot edit data using SSRS reports.Siddharth Mehtahttps://www.blogger.com/profile/02870225483799389119noreply@blogger.comtag:blogger.com,1999:blog-11909584.post-10774639567735097742011-05-06T03:59:47.355-07:002011-05-06T03:59:47.355-07:00hello Siddharth,
Do u have any idea about how to ...hello Siddharth,<br /><br />Do u have any idea about how to enable editing a column in database via SSRS. please respond earlier i m waiting for ur quick response.<br /><br />Thanx<br />RohitRohit Tiwarihttps://www.blogger.com/profile/05355369791157175197noreply@blogger.comtag:blogger.com,1999:blog-11909584.post-43024876097760524572010-08-08T20:15:31.219-07:002010-08-08T20:15:31.219-07:00One option is, create a schedule in SQL Agent that...One option is, create a schedule in SQL Agent that runs every hour. Create a job using this schedule and execute SSIS package. This SSIS package can call SSRS webservice and generate all your reports. You can configure your SSIS package to generate reports based on your time requirements. But then you would have to deal with the report delivery.<br /><br />Another option is you can add/remove or enable/disable selected subscriptions for the report using SSRS webservice from SSIS or by querying report server database using T-SQL. And this SSIS package or TSQL script can be executed at required time intervals through a SQL Server Agent job. The following links would help you in what you are looking for.<br /><br />http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/4d14759c-b7fc-4d23-b148-f742f56b03b8<br /><br />http://www.codeproject.com/KB/reporting-services/DynamicSSRSSubscriptions.aspxSiddharth Mehtahttps://www.blogger.com/profile/02870225483799389119noreply@blogger.comtag:blogger.com,1999:blog-11909584.post-86591748415366062010-08-08T17:29:49.479-07:002010-08-08T17:29:49.479-07:00Good article and thanks for sharing.
I am finding...Good article and thanks for sharing.<br /><br />I am finding the scheduling options in SSRS is very limited. If I have to schedule a report every hour from 9.00 AM to 5.00 PM Can't do it is SSRS but use SQL Job scheduler to fine tune it.<br /><br />I am thinking of doing something like this using SSIS, whereby I can create a schedule using SSRS webservices from data stored in a table. or USE SSIS to run the report at aspecified intervals.<br /><br /><br />Any thoughts ??<br /><br />Regards<br /><br />Jimmy GeorgeJimmy Georgehttps://www.blogger.com/profile/11903925875311316153noreply@blogger.com