Results 1 to 4 of 4

Thread: Is it possible to export data automatically from reporting services ?

  1. 09-01-2010, 11:54 AM #1
    OpenAccess
    OpenAccess is offline Registered User
    Join Date
    Sep 2010
    Posts
    3

    Is it possible to export data automatically from reporting services ?

    Hi,

    I want to export data from the result of a report in an SQL Table.

    Anybody Knows if this is possible in Reporting services (may be with embedded code )?

    Thanks for your help.
    Reply With Quote Reply With Quote
  2. 09-04-2010, 05:13 PM #2
    J013
    J013 is offline Registered User
    Join Date
    Jan 2010
    Posts
    37
    What do you want to export it to? If it is to a text file or Excel spreadsheet, then you can setup a SSIS package and run it via a SQL job to export your data automatically.
    Reply With Quote Reply With Quote
  3. 09-05-2010, 03:20 AM #3
    OpenAccess
    OpenAccess is offline Registered User
    Join Date
    Sep 2010
    Posts
    3

    Thumbs up execute a package SSIS from Reporting services

    Hi J013,

    Thanks for your useful answer.

    Do you know if it is possible to execute a ssis package (or batch file) from an ACTION (or CODE) in Reporting services ?

    Best Regards

    Open Access
    Reply With Quote Reply With Quote
  4. 09-05-2010, 04:15 AM #4
    J013
    J013 is offline Registered User
    Join Date
    Jan 2010
    Posts
    37
    Good question. I am not sure. You could probably program something in ASP.Net to execute a SSIS pacakge and embed that into the report, but I have not read anything about executing SSIS packages from within SSRS being inherently built into SQL.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules