Post reply

Generating Reports with Integration Services

  • December 9, 2009 at 9:26 am

    #213296

    Hi

    We produce several reports each week/month and I'm investigating the possibility of automating these either completely or partially.

    Some are as simple as running a query and displaying the results under headed columns in an Excel spreadsheet. Others may involve using conditional formatting or, at present, a fair amount of copy/pasting into various worksheets within a workbook.

    I am able to set up integration services to perform the queries and output the results into a text format or even email it.

    I'd now like to format the output, perhaps even create charts etc. Can anyone point me in the right direction? Can Integration Services even perform such tasks?

    Thanks in advance for any advice.

    Cheers,

    Chris

  • December 9, 2009 at 9:29 am

    #1089970

    [font="Comic Sans MS"]

    Interesting question and I would love see any advise on this ...

    [/font]

    [font="Comic Sans MS"]--
    Sabya[/font]

  • December 9, 2009 at 10:06 am

    #1090007

    Is Reporting Services not an option for you? It does most everything you are asking for.

    [font="Arial Narrow"]bc[/font]

  • December 9, 2009 at 1:33 pm

    #1090197

    Hi. I was looking at reporting services previously. The problem is I think I need a combination of the 2 to email reports and so on. How would you recommend doing this?

    Thanks

  • December 9, 2009 at 2:04 pm

    #1090213

    Reporting Services has the functionality to send reports via email subscriptions and rendered in a variety of formats. The only thing I see in your original request that would be problematic is a multi-sheet spreadsheet.

    I would put a question in on the Reporting Services forums or read up on it in BOL.

    Thanks,

    [font="Arial Narrow"]bc[/font]

  • December 10, 2009 at 9:30 am

    #1090666

    bc_ (12/9/2009)

    Reporting Services has the functionality to send reports via email subscriptions and rendered in a variety of formats. The only thing I see in your original request that would be problematic is a multi-sheet spreadsheet.

    I would put a question in on the Reporting Services forums or read up on it in BOL.

    Thanks,

    Thanks. I've been looking at this today and have a couple of easy reports done and subscribed to. The more complex ones should be fun! :w00t:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply