June 10, 2012 at 6:12 pm
I am fairly new to T-SQL and am taking over a weekly process that hoping can be streamlined a bit. Can someone tell me how I might kick off a process that brings some data files into a SQL database and then runs some reports summarizing the results? I am thinking it will involve running an SSIS package and then some reports in SSRS. Is there some way to combine this process? Can I run a report from within SSIS or create a job that runs an SSIS package and then runs a set of reports in SSRS? Or is there another way to do this that I am not aware of? Any help would be greatly appreciated.
TIA,
Jon
June 11, 2012 at 5:35 am
A few ways exists to complete this process. One idea I can think of is to create your import process via SSIS, and then setup a supscription for the SSRS piece. Once the subscription is setup, it will create a SQL Agent job, which you can ID. Then you can create single SQL Agent job with step 1 that first calls the SSIS package (or whatever import process you come up with), and a second step to mimic the Subscription job.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply