<div>
No. The stored proc which I want to run execute an SSIS package.... it's a long story !!
</div>


<div>
This person has used connected to the SSIS package through SSRS. <br />
<br />
<a href="http://www.bigresource.com/Tracker/Track-ms_sql-ICBVyj4e/" rel="ugc">http://www.bigresource.com/Tracker/Track-ms_sql-ICBVyj4e/</a><br />
<br />
I am not sure how to write connection strings?
</div>


<div>
<div class="content wysiwyg-content">
Is it possible to create a custom button in SSRS to launch a stored proc.<br />

</div>
</div>


Is it possible to create a custom button in SSRS to launch a stored proc.


No. The stored proc which I want to run execute an SSIS package.... it&#39;s a long story !!

This person has used connected to the SSIS package through SSRS. 

http://www.bigresource.com/Tracker/Track-ms_sql-ICBVyj4e/

I am not sure how to write connection strings?

Is it possible to create a custom button in SSRS to launch a stored proc.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications