I'm just starting out with SSIS and I'm currently looking to migrate some non-SSIS ETL processes to SSIS. Some of these processes are run manually depending on the results from a previous step. In these processes a user remotely executes an individual ETL program and is shown reports detailing the result of the program and various statistics about the data involved.
Is it possible to replicate this behaviour with SSIS / SSRS, or would the user have to execute a package and then manually find and bring up each of the relevant reports?
I'm new to SSIS and I'm still struggling to find out SSIS's capabilities, so I'd be really grateful if anyone could shed some light on this...
Thanks in advance,
Lawrie.
If you have one report, it is possible to stream data directly into SSRS from SSIS. In this case SSRS report uses SSIS as data source. See Books Online for detailed instructions.
Or (this works for multiple reports as well) you can simply start several IExplore.exe using Execute Process tasks and point them to URLs of appropriate SSRS reports - they are usually published to a web server, so you can view them in IE.
No comments:
Post a Comment