.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Can I Call SSIS From SSRS

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server


I have a problem to solve where it might be a good solution to execute an SSIS package from an SSRS report. I've done some google'ing but I can't seem to find a discussion about this particular topic. Does anyone know if this is possible and if so, have any info they can share about how to implement this.



View Complete Post

More Related Resource Links

How to export SSRS report to PDF from SSIS with parameters

Hello everyone.  I am trying to setup a process in which a user, who is using a vb.net 2008 application, will need to  trigger the creation of two items.  The first is  SSRS report which will need to be exported to PDF format to a shared folder on the network.  This report accepts one parameter.  The second thing that will need to be created at the same time is an excel file with data exported from SQL Server 2008 which is generated through an SSIS package.  A couple things to note.  The excel file and the pdf file need to have the same file name, other than the extension.  For example P00000001_20100831.pdf and P00000001_20100831.xlsx and will both be stored in the same network share.  The filenames need to be created dynamically at run time and will be based on a parameter being passed to the report. So far I have the portion that creates the excel file working fine.  The way I create that is as follows.  I have a stored procedure that creates a job which calls the SSIS package and passes the appropriate parameters to the SSIS package.  After the job is created I immediately run it and then delete the job.  Ok, everything works fine with that. Now I cant seem to figure out how to get the pdf created.  If possible I would like to keep this portion together with the already created job or package.&nb

How to call SSIS Package through web service based on ASp.NET using C#

Hi All, How to call SSIS Package through web service based on ASp.NET using C#.   Regards Amit

extracting from multiple tables in an odbc call/ssis

Hi,   I have an odbc for DBISAM, and can use it to import into sql server, but only one table at a time.  (when it get's to the choose table screen, it will only let me create a single SQL query.   does anyone know if I can extract from multiple tables using this?   If not - what would I need to change in the DTSX file so that my query goes from "select * from tablea" to "select * from tableb" and the destination table is also "tableb"?   also - can the DTSX file be change to run for multiple tables?

SSIS - Call a Store procedure

Can someone show me an example of how to call a store procedure that checks for empty fields in a SQL database table, by returning a value when fields are empty. then send an email to the adminstratore.

call SSRS report in asp.net application

hi all I am using following code to call a report in a ap.net application but its output is " The request failed with HTTP status 401: Access Denied"........ kindly resolve..... ##############C O D E ################### Partial Class Report1     Inherits System.Web.UI.Page       Public Class ReportViewerCredentials1         Implements IReportServerCredentials         Private _userName As String         Private _password As String         Private _server As String         Public Sub New(ByVal userName As String, ByVal password As String, ByVal server As String)             _userName = userName             _password = password             _server = Server         End Sub         Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser             Get   &n

How can a proc call another proc in SSIS?

My first proc retireves two parameter values and then executes a second proc using those parms as input parms and populates a dest table Proc 1 exec  p_getdata parm1,parm2  this works fine in sql server resulting in a populated destination table What is best way to accomplsh this in SSIS?  

SSIS 2005: call WCF web service in ScriptTask (?)


Hi I am a bit of SSIS and WCF newbie...I am working on a SSIS 2005 project and other company writes web service for me to consume.  I use "script task" in SSIS and copy the WSDL-generated proxy file to consume web service..it has been working ok but yesterday I got a new proxy class file from the other company with heading like this:


<System.Diagnostics.DebuggerStepThroughAttribute(), _

     System.CodeDom.Compiler.GeneratedCodeAttribute("System.Runtime.Serialization", ""), _

     System.Runtime.Serialization.DataContractAttribute(Name:="GetBondTenancy", [Namespace]:="http://xxx.x.xxx.notshown.xxx/")> _

    Partial Public Class GetBondTenancy

        Inherits Object

        Implements System.Runtime.Serialization.IExtensibleDataObject

SSIS complains about not recognizing 'DataContractAttribute' and 'IExtensibleDataObject' but sure it is not just a matter of DLL referencing... is there a way I can consume this Web service?

p.s. Please let me know if you guys require more info....

SSIS as data source in SSRS


I have a connection string

="/f c:\test\test2\test2\package.dtsx /set \package.variables[User::varfil].Value;" & Parameters!varempid.Value

but its not returning any results.

SSIS as data source in SSRS connection string


I have a connection string

="/f c:\test\test2\test2\package.dtsx /set \package.variables[User::varfil].Value;" & Parameters!varempid.Value

but its not returning any results. I need a valid connection string.

How do I call an SSRS Report from a stored procedure, and pass parameters?


Hi all,

I have a Report, that I want to run ad-hoc from a Stored Procedure. 

I want to render this report to PDF format, and save it to a drive.

The difference between this post and most threads I've seen is I don't want to run a stored proc within the report and send parameters to the stored proc.

I DO want to call a report FROM the stored proc, and send parameters TO the report.

How can I do this?

Many thanks,


how to call multi-value parameters in SSRS from asp.net application?


hi all

i am trying to call an SSRS report (in VS 2005) from my asp.net (web application) implemented in VS 2008 (don't ask me why, i am kind of confused by this weird arrangement too). report has been deployed to report server and it contains a multi-value parameter.

when i call report from asp.net app, i set the value for this multi-value parameter as a string and all selected values are separated by comma. i.e. i have 5 options (a, b, c, d, e), and i selected first two, the string is then "a,b".

the multi-value parameter on the report side is defined as: Multi-value selected, Allow blank selected, Avaliable values are from query (a dataset that contains a, b, c, d, e) Value field and Label field are both mapped to dataset filed (there is only one field in the dataset). the default values are from query too (same dataset). value field is mapped also.

i have two problems:

1: it looks to me that all available values are selected on the report side, regardless what i really selected and passed over (when i turn on paramters).

2: when i turn off parameters, i need to display what values being selected as a string, the join statement, join(Parameters!TeamLead.Value), gives a list of all available values for the multi-value parameter, however, i only need selected values. h

Is there any Sharepoint 2010 Webservice call that I can point my SSRS Report at to retrieve an execu


I want to create an SSRS report that displays all the steps in an executing workflow along with its current stage.

SharePoint 2010 webpart shows the current state of the executing workflow but I want to display all the steps including ones that have been completed and ones that are still to come.

Call a SQL Server function(cleans html tags) on a derived column in SSIS


I have a task to move table having "text" data type for a column from SQL Server to CSV file so while transfering the data using SSIS I want to perform Cleanup on this column such as removing HTML tags, White spaces etc and then transfer it. Note: I dont have any option to store the table in the staging database as I will be running it on the production server directly.

Can any one help me accomplish this task???





How to call Oracle Stored Procedure which has an output parameter from SSIS?


I will really appreciate if someone can post step by step process to call an Oracle Stored Proc from SSIS. Here is the Stored Proc Spec:


    PROCEDURE Interface_Begin

    (p_from_dttm       OUT varchar2,

     p_error_code            OUT number,

     p_error_text       OUT            varchar2,

     p_proc_name        OUT varchar2);  


SQL Server 2005 cluster install with SSRS and SSIS - best approach for installs and migration?


I just installed SQLServer 2005 STD edition SP3 on an active/passive 2 node cluster, Intended to replace a SQLServer 2005 sp3 EE install (not clustered) that is in production now using SSIS and SSRS.  I would need to migrate the databases, reporting, and Integration Services over to the new server cluster.  


1.    Does it make sense to run on a SQL Server 2005 on a cluster if SSIS and SSRS are not cluster aware? This is my 1st time adm

C# Code Call SSRS Subreport from ReportViewer


Any C# Code or any setting in Reportviewer to call SSRS Subreport from ReportViewer

The SSRS Subreport executes properly from report manager.

How can SSRS call to .net application....


 Dear sir/madam,

           I am amar patil I have try to SSRS call to used in .net application

so can you possible to the SSRS call to the .net application. any type of

solution please seng the link of url.


Thank's &Regrad's,

Amar Patil.

Mobile No:-9987721852


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend