Sunil Reddy Enugala

…..is just walking through MSBI Street.

Execute SSRS report from SSIS package

Posted by Sunil Reddy Enugala on December 27, 2011

Hi, Today my post is on ‘How to execute and render SSRS report (Excel format) from SSIS package’.

Am assuming a SSRS report (Employee Details) which accepts ‘Department’ as parameter, please have a glance at the Employee table and Report generated for particular department.

image

clip_image002

I’ll explain you how am going to execute the ‘EmployeeReport’ report from SSIS package.

Note:

@parameter1’ is the parameter which am passing to the report, please go through the ‘Dataset properties’ figure of SSRS, we need to use the same name in the SSIS package.

clip_image012

Create a SSIS package and Drag Script task into the design pane and before editing change the ‘Script language’ property to ‘Microsoft Visual Basic 2008

clip_image004

Variables in SSIS package:

  • User::FileExtension - To generate report with given File extension.
  • User::FileType - File Format name of given file extension.
  • User::FullFilePath - To generate file in given file path.
  • User::Filename - To dynamically name the generated file.
  • User::Parameter1 - To pass parameter to the SSRS report.

Right click on  ‘Script task’ and select ‘Edit’. Select FileExtension, FileType, FullFilepath, parameter1 as ‘ReadOnlyVariables’

clip_image006

After selecting ‘ReadOnlyVariables’, click on ‘Edit Script’.

image

Web Reference:

We need to add ‘ReportExecutionService’  as a web reference, right click on the class name and select ‘Add Web reference’ property.

clip_image008

Paste ‘http://localhost/reportserver/ReportExecution2005.asmx?WSDL’ in the URL box.

In the above URL localhost  refers to the server, reportserver refers to the virtual directory. To know the virtual directory name, open Reporting Services Configuration manager –> click on Web Service URL then refer to the Reporting Server Web Service Virtual Directory name, as shown in below figure.

image

Click on GO button, we’ll get the description regarding ‘ReportExecutionService’ and click on ‘Add reference ‘ after giving some name to the Web reference(‘localhost’ in my example).

clip_image010

Script task Code (Microsoft Visual Basic 2008)

We need to import ‘System.IO’ class to deal with File stream objects, please go through below figure for the Script task code.

image

‘.LoadReport("/EmployeeReport/EmployeReport", Nothing)’ : ‘/EmployeeReport/EmployeReport’ is where the Report stored in Report Manager.

Report will be generated in the given File path with ‘Report name’ as the ‘Excel sheet name’

clip_image016

Let me know your comments on my Post.

Sunil Reddy Enugala

About these ads

74 Responses to “Execute SSRS report from SSIS package”

  1. Gunder said

    Hi,

    This is a very great description of how to execute SSRS reports from SSIS and it covers exactly my needs I am a litte bit of a rookie into this and I get an error message when I execute the script task. Can you give me a hint to what I am doing wrong:

    Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.
    —> System.Runtime.InteropServices.COMException (0xC0010009): The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.

    at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSVariables100.get_Item(Object Index)
    at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index)
    — End of inner exception stack trace —
    at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index)
    at ST_b20d92503be841a68d4cdc28aeae6deb.vbproj.ScriptMain.Main()
    — End of inner exception stack trace —
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
    at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
    at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()”

    Thanks in advance

    • Tej said

      Hello Gunder,

      I am not .net person to code but trying to follow steps mentioned above. I do not get “.LoadReport” option under “With objRSExec” code whiile writing code. I imported System.IO too.

      I am getting below error message when I move mouse cursor above this line
      .loadreport = (“myfolderpath”, Nothing)
      Error message is “LoadReport is not member of ST………(my class name)”

      Please suggest.

  2. Gunder said

    I fount that above error happend because of a misspelled variable in the script code.

    • RM said

      Hi Gunder ,

      I have the same situation . can you tell which variable is misspelled in the script code? I’m thinking about that my path for .LoadReport is not correct.

      thanks

  3. Sunilreddy said

    Hi Gunder, am glad that my post reached you. let me knw the further issues you faced with this approach.

  4. Jay said

    This is a great write up. Thanks!

    I have a question: How do I pass in multiple parameters into a report?

    • Sunilreddy said

      Hai Jay,
      good question, you can pass multiple parameters by using the following 2 steps

      step 1: declare the parameters.

      With objParamParameter1
      .Name = “Parameter1″
      .Value = Dts.Variables(“User::parameter1″).Value //SSIS Variable
      End With

      With objParamParameter2
      .Name = “Parameter2″
      .Value = Dts.Variables(“User::parameter2″).Value //SSIS Variable
      End With

      Step 2: Point to a array varable and pass.

      objParams(0) = objParamParameter1
      objParams(1) = objParamParameter2

      With objRSExec

      .Credentials = System.Net.CredentialCache.DefaultCredentials
      .Url = “http://localhost/reportserver/reportexecution2005.asmx”
      .LoadReport(“/SSRSReport/ReportExample”, Nothing)
      .SetExecutionParameters(objParams, “en-us”)
      objResult = .Render(strFileType, Nothing, strFileExtension, Nothing, Nothing, Nothing, Nothing)

      End With

      Let me kn0w if you have any further queries.

  5. petrica said

    This is an amazing post. Thank you very much for the efforts.

  6. Sunilreddy said

    Thank you for the comment Petrica…

  7. David said

    I am still getting the error Gunder had. Can you provided sample values for the parameters? Does FileExtension need to be .xls or just xls, what should FileType be, and should FullFilePath be UNC \\server\folder or can it be C:\folder? Cheers!

    • Sunilreddy said

      Hi David, FileExtension should be ‘.xls’
      FileType ‘Excel’ and
      FilePath C:\folder
      I never tried with remote path, i’ll let you know regarding that soon…

      • Jay said

        I’ve used remote paths, but you need to make sure you have all the appropriate permissions. Example: \\Some-sql12\Test\Exports\Test\2012-04-25_Report.pdf

      • Sunilreddy said

        Great jay, I didn’t find an oppertunity to test that. i’ll definitly reach you I face any issue while working with remote paths, and thanks for the information. :-)

  8. David said

    Thanks, got it working. In addition to having some variable problems I also had a typo in the script. Cheers

  9. Jay said

    I also have some code i use which loops through a parameter table and dynamically assigned parameters to a report. I can share the code if anyone wishes. It’s worked well and we send out a ton of reports on a daily basis.

    I do have another issue though. Sometimes the script task fails due to a timeout error:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.Net.WebException: The operation has timed out
    at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)

    If I manually run the report it takes over a minute to generate. Which is expected since its a 500 page report.
    I am not sure how to increase the timeout of the script task ( I am not sure if SSIS has that feature).

    • Sunilreddy said

      Hi Jay, have you tried setting the Timeout option of web service. In the above script task code
      you can find Timeout option in objRSExec object, though I didn’t used but you’ll definitly
      find that option.

      or else you can change in the web config file.

      • Jay said

        It still seems to have a timeout issue. This is the code I used:

        With objRSExec
        .Credentials = System.Net.CredentialCache.DefaultCredentials
        .Url = “http://localhost/reportserver/reportexecution2005.asmx”
        .LoadReport(“/Reports/” & strReportName, Nothing)
        .SetExecutionParameters(objParams, “en-US”)
        objResult = .Render(strReportFormat, Nothing, strReportExt, Nothing, Nothing, Nothing, Nothing)
        .Timeout = 5000000
        End With

      • Anonymous said

        Hi Jay, Have you tried the timeout option of webservice.

    • Duane said

      Hi Jay,

      I would love to see the code you use. What you are doing sounds exactly what I am looking for. Can you email it to me?

  10. […] Execute SSRS report from SSIS package […]

  11. […] Execute SSRS report from SSIS package […]

  12. Chjquest said

    Hi,
    Thank you for this great post.
    I’ve read and only got one problem.
    When I tried to execute the task, I got an error when the task tries to access the folder, it was denied. It was a System.IO part error which the task tried to write something to the specified folder.

    Don’t know if you have any suggestion over this ?

    Thanks.

    Chi

  13. Sunilreddy said

    Hi Chi,

    Open dcomcnfg

    right click > My Computer >properties >COM Security

    Under Access Permissions: Add Network Services and Users grant Local Access to each

    Under Launch and Activation Permissions: Add Network Services and Users, grant Local Launch and Local Activation to each.

    Give full control permission to the ‘NETWORK SERVICES’ user for the folder in which the file is being generated.

    Hope this solves your issue.

    Thanks
    Sunil Reddy

    • Chjquest said

      Thanks, solved with your way.
      Great appreciation~

    • safwan said

      Dear Sunilji,

      I have tried the method you said above no luck still the same. I am suing Win Server 2008 r2 SBS 64 bit. I hope some help.

    • Shalini said

      Hi Sunil,

      Thanks for the great post. I have one question: i’m unable to execute the script as it shows error Access to path is denied.

      Access to the path C:\Applications’ is denied.
      at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
      at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
      at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
      at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
      at ST_0d8f581e76f74cf48ac34ac50e68bf7a.vbproj.ScriptMain.Main()

      I was looking for how to change COM settings but I could not find it in WIndows 7. Can you please tell me how I can change the settings here.

      thanks,

  14. click this said

    Not what I was looking for but excellent anyway! Congrats!

  15. Anonymous said

    Hi,

    I have created SSIS package using BIDS 2008 and added Script Task.
    When I try to add ReadOnlyVariables I am getting System variables, I am not getting User variables as you have mentioned in your post.

    ■User::FileExtension – To generate report with given File extension.
    ■User::FileType – File Format name of given file extension.
    ■User::FullFilePath – To generate file in given file path.
    ■User::Filename – To dynamically name the generated file.
    ■User::Parameter1 – To pass parameter to the SSRS report.

    Could you please help me how can i get these variables.

    Its very urgent for me.

    Thanks in advance
    DBill

  16. meera999 said

    Hi,

    I have created SSIS package using BIDS 2008 and added Script Task.
    When I try to add ReadOnlyVariables I am getting System variables, I am not getting User variables as you have mentioned in your post.

    ■User::FileExtension – To generate report with given File extension.
    ■User::FileType – File Format name of given file extension.
    ■User::FullFilePath – To generate file in given file path.
    ■User::Filename – To dynamically name the generated file.
    ■User::Parameter1 – To pass parameter to the SSRS report.

    Could you please help me how can i get these variables.

    Its very urgent for me.

    Thanks in advance
    Meera

  17. comprehensive search marketing specialist l comprehensive search marketing strategies l search marketing specialist l comprehensive search marketing l internet marketing specialist l Scottsdale SEO Company l Web marketing specialist l Online marketing spe said

    Someone essentially help to make critically articles I’d state. This is the very first time I frequented your website page and so far? I surprised with the research you made to make this particular put up incredible. Excellent activity!

  18. Hu Gross said

    Would you be able to do anything far more advanced

  19. casino online said

    An individual got what beyond the jaws but I really could not need expressed the item much better than an individual, Chapeau for this!

  20. meera999 said

    I am trying to created SSIS package for bulk upload of my ssrs reports.
    But I am not getting below variables in ssis package, i have all system ::….variables.

    Variables in SSIS package:
    ■User::FileExtension – To generate report with given File extension.

    ■User::FileType – File Format name of given file extension.

    ■User::FullFilePath – To generate file in given file path.

    ■User::Filename – To dynamically name the generated file.

    ■User::Parameter1 – To pass parameter to the SSRS report

    Could you please let me know how can i get all these user variables?

    Appreciate your help.

    • Sunilreddy said

      Hi, Create those variables in your SSIS packages with the scope of your Package or script task, than you can find those variables in that tab. Check for the variables with the naming convention as user::

      Thanks for visiting my blog, hope it will help you now.
      let me know if the issue solved.

  21. Torebki Damskie said

    I do agree with all of the ideas you’ve presented in your post. They are very convincing and will definitely work. Still, the posts are very short for novices. Could you please extend them a bit from next time? Thanks for the post.

  22. file extension flv said

    I am also appreciating this blog info, thanks for giving the suitable example…..!

  23. Do you mind if I quote a few of your posts as long as I provide credit and sources back to your
    webpage? My website is in the exact same niche as yours and my visitors would genuinely
    benefit from a lot of the information you provide here. Please let
    me know if this ok with you. Regards!

  24. Anonymous said

    I’m trying to use this to run an excel report from Visual Studio 2010 SSRS from SSIS. Would this work?
    I just ran it and got the following message:
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
    at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

    • Sunilreddy said

      Could be a path problem, when you are moving the file, the source only has the source file name. It should have the complete path.

      Can you catch the inner exception and let me know.

  25. if i dont have any parameter in my report then…in that case what is the script..for call ssrs report in ssis..????

    • Sunilreddy said

      if you don’t want to use Report Parameters, you can exclude the content related to parameters in the Script. But my suggestion is not to follow the above mentioned approach if you don’t have parameter. There are other best ways to which will do the same.

  26. Anonymous said

    That is absolutely what I’ve been looking for…!! THANK YOU..

  27. Anonymous said

    great post. But I have a problem which the script runs sucessfully when it runs inside the Visual Studio, but cannot run the SSIS package in SQL agent or double click on the SSIS file to execute, didn’t see detail error, just says failed.

  28. Sudhakara Rao Allam said

    Hi, I am unable to save the report to local. I gave explicit permissions to the folder to “NETWORK SERVICE”. Error message says unauthorized access.

    • Sunilreddy said

      Hi Sudhakar, As discussed above(in a response to Chjquest), giving explicit permission to NETWORK SERVICE user for the folder (in which you’ll need to generate report) should solve the issue.

      Can you give further information on error message.

  29. Msbilearning said

    My requirement is after certain load in SSIS,I want to add this task and after It i want to subscribe it to go in mail.
    What Should be done in addition to this to subscribe the report?

    • Sunilreddy said

      Hi, You have two ways to implement.

      1. Use the above task and render the report in required format. Use system procedure to send E-mail with file attachment.
      [USE msdb]
      GO
      EXEC sp_send_dbmail
      @profile_name=,
      @recipients=,
      @subject=,
      @body=,
      @file_attachments =

      as already hold filename in a variable, pass it to above system procedure.
      Note: Database Mail profile is pre-requisite.

      2. when you create subscription for a SSRS report, a job will be created automatrically which will trigger on given schedule time. To find the details of the job, use the following query.
      SELECT c.Name AS ReportName, c.Path AS Report_Path,
      rs.ScheduleID AS JOB_NAME, s.[Description], s.LastStatus
      , s.LastRunTime,c.CreationDate,c.ModifiedDate
      FROM ReportServer..[Catalog] c
      JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID
      JOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID
      AND rs.SubscriptionID = s.SubscriptionID

      After the extraction in SSIS use ‘Execute SQL Server Agent Job Task’ to trigger the job.

      Let me know if it helps.
      Thanks…
      Sunil Reddy

  30. Kishore said

    Hi All,

    I am facing some problem after successfully creating the file in given path. The problem is, the excel file which is created from SSRS report is been used by SSIS script task and we are unable to use the same file while sending the email.

    Just for confirmation:
    we have used the CLOSE, FLUSH and DISPOSE option of file stream object to release the process but we are not having any luck…

    any suggestion to solve our problem.

    Thanks..
    Kishore

  31. I’m really enjoying the design and layout of your site. It’s a
    very easy on the eyes which makes it much more pleasant for me to come here and visit more often.
    Did you hire out a developer to create your theme?

    Great work!

  32. Wayne said

    Hi Sunilreddy

    Really great post I am relatively new to the VBScripting thing, this is exactly what I am looking but the only difference is that I want to email the report and not save it to a file location, do you have some suggestions.

  33. Sunilreddy said

    Hi Wayne, create a Data driven subscription for that report and use the job of that subscription.

  34. Sue Neilson said

    This is a brilliant post – but being a complete novice, I can’t see how you are setting the user variables with values! Plus I have a step before this that imports some data that I then want to report on. The parameter for my report is a field from the import file. How can I set this please?

  35. Tej said

    Hello, in my project xml web service info is in the ReportService2010.asmx, that is why did not get web reference with execution URL. Resulting I used ReportService2010.asmx to add reference and sucessfully added. But now I do not get “.LoadReport” option under “With objRSExec” code. (FYI…I imported System.IO too.)

    I am getting below error message when I move mouse cursor above this line
    .loadreport = (“myfolderpath”, Nothing)
    Error message is “LoadReport is not member of ST………(my class name)”

    Please suggest.

  36. satish said

    Thank you……

  37. Jay said

    Back again!

    Still have the timeout issue, and now it’s really getting bad. It seems to occur on multi page PDF report generation.
    –I’ve increased the timeout in both webconfigs (report manager report server)
    –made sure that the report itself doesn’t time out by settimg the report manage option to “Do not timeout”
    –I also set the objRSExec .timeout = 600000
    –i increased every timeout I coudl find in the rsreportserver.config file.
    No luck on any of these.

    Here is the error again, which occures on the SSIS script task. Please help!

    Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.Net.WebException: The operation has timed out at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ST_41eea98f5e9e4291b67835c66c2c33b5.vbproj.localhost.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) at ST_41eea98f5e9e4291b67835c66c2c33b5.vbproj.ScriptMain.Main()

  38. Tina said

    Your solution was exactly what I was looking for, when I found it. Now, I am trying to extend it. Do you know how or if it can be modified to execute a subscription instead of directly calling the report? Any help you may be able to provide would be greatly appreciated!

  39. Anonymous said

    Brilliant, Thanks

  40. Nik said

    Thanks for the post.Iam trying to add SSRS reference in SSIS 2012 .I have added the web references and code as per ur doucmentation .I could build the script successfully . But when I come out of the VSTA ,the script task is showing me error that binary code not generated . Am I missing something ? .. In a seperate script task I tried adding the web reference alone ,without adding any code .This is showing me error.Anything that we do ensure before adding web service please confirm .

  41. kumar said

    Hi
    I am getting following error while adding “Add web reference ”
    There was an error downloading ‘http://reportservermssqltest/ReportExecution2005.asmx?WSDL’.
    The remote name could not be resolved: ‘reportservermssqltest’

    Please help me

  42. Reshma said

    Thanks for the post.

  43. Jhon Alexander Orozco said

    hi, is possible create your code for C#, because I don´t can define the variables type

    Thanks for your answer

    • localhost.ReportExecutionService objRSExec = new localhost.ReportExecutionService();
      localhost.ParameterValue objDepartment = new localhost.ParameterValue();
      localhost.ParameterValue[] objParams= new localhost.ParameterValue[1];
      byte [] objResult = new byte[1];
      FileStream objStream;
      string strFileType;
      string strFileExtension;
      string strFullPathName;

      strFileType = this.Dts.Variables[“FileType”].Value.ToString();
      strFileExtension = this.Dts.Variables[“FileExtension”].Value.ToString();
      strFullPathName = this.Dts.Variables[“FullFilePath”].Value.ToString();

      objDepartment.Name= “Fecha”;
      objDepartment.Value= Dts.Variables[“Fecha”].Value.ToString();
      objParams[0]= objDepartment;

      objRSExec.Credentials= System.Net.CredentialCache.DefaultCredentials;
      objRSExec.Url= “http://localhost/reportserver/reportexecution2005.asmx”;
      objRSExec.LoadReport(“/ReportFileEdi/SuccessReport”,null);
      objRSExec.SetExecutionParameters (objParams, “en-us”);

      objResult[0]= objRSExec.Render( strFileType,null,strFileExtension,null,null,null,null);

      objStream= File.Create(strFullPathName, objResult.Length);

      objStream.Write(objResult, 0,objResult.Length);
      objStream.Close();

      Dts.TaskResult = (int)ScriptResults.Success;

  44. Anna said

    hi,

    this post is very helpful. but I have a problem when I try to add web refferences to my project. I put the report server just you show us, but where I have to define the name of webreferences is inactive and I got this error:

    The HTML document does not contain Web service discovery information.
    There was an error downloading ‘http://server/ReportServer_SQL2012/Pages/ReportViewer.aspx?%2fReminderCRM&rs:Command=Render/$metadata’.

    Can somebody help me pls?

  45. Tom said

    Perfect – Thanks!

  46. Good respond in return of this question with firm arguments and describing all regarding that.

  47. Very informative. There is a lot of good infromation and advice here.

  48. Oh my goodness! Amazing article dude! Thanks, However I am encountering issues with your RSS.
    I don’t understand why I am unable to subscribe to it.

    Is there anyone else having the same RSS issues? Anyone
    who knows the answer can you kindly respond? Thanks!!

  49. I do not even know how I ended up here, but I thought this post was great.
    I do not know who you are but certainly you are going to a famous blogger if
    you are not already ;) Cheers!

  50. AJV said

    Hello Sunil – It’s me again .:)
    To start with , for my SSIS package what should be the data connection. Do I need to have any as it is referencing the web service? This is the first time I am creating a SSIS package
    Another thing is you stated there are better ways to trigegr the reports and email(subscription) could you please let me know what they are.
    Can I place the SSIS package on any server which does not have SSIS/SSRS installed and just call it ?

    Regards
    >>>>>>>>>>
    AJV

Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 661 other followers

%d bloggers like this: