Interactively showing reports detailing results/stats of executing a package?

Hi,

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.

integration ok SQL 7 server in Active Directory 2003 ?

my company plan to migrate NT environnemen to Active directory 2003
environnement.
We have three SQL server, one SQL 2000 SP3entreprise en 2 SQL 7 servers sp4.
i want to kow if we make an on place migration if the NT authentification
will be ok when we ll have AD 2003 ( i know that there is no problem with
SQL2000 but i want to know if there is any problem with NT authentification
in AD 2003 environnement with SQL 7 servers ).
thanks about your reponse
olivier blanchard
FranceThere are no problems with NT Authorisation of SQL 7 when
you convert from 2000 to 2003.
Peter
"Facts are stupid things."
Ronald Reagan
>--Original Message--
> my company plan to migrate NT environnemen to Active
directory 2003
>environnement.
>
>We have three SQL server, one SQL 2000 SP3entreprise en 2
SQL 7 servers sp4.
>
>
>i want to kow if we make an on place migration if the NT
authentification
>will be ok when we ll have AD 2003 ( i know that there
is no problem with
>SQL2000 but i want to know if there is any problem with
NT authentification
>in AD 2003 environnement with SQL 7 servers ).
>
>
>thanks about your reponse
>
>
>olivier blanchard
>France
>.
>|||hi , thanks for your answer but my question is:
is there any problem with Nt authentification (on SQL7 server) when i
migrate my SQL7 server (which is in NT4 domain) to a Active Directory 2003
environnement?
thanks for your answer
"Peter The Spate" wrote:
> There are no problems with NT Authorisation of SQL 7 when
> you convert from 2000 to 2003.
> Peter
> "Facts are stupid things."
> Ronald Reagan
>
> >--Original Message--
> > my company plan to migrate NT environnemen to Active
> directory 2003
> >environnement.
> >
> >
> >
> >We have three SQL server, one SQL 2000 SP3entreprise en 2
> SQL 7 servers sp4.
> >
> >
> >
> >
> >
> >i want to kow if we make an on place migration if the NT
> authentification
> >will be ok when we ll have AD 2003 ( i know that there
> is no problem with
> >SQL2000 but i want to know if there is any problem with
> NT authentification
> >in AD 2003 environnement with SQL 7 servers ).
> >
> >
> >
> >
> >
> >thanks about your reponse
> >
> >
> >
> >
> >
> >olivier blanchard
> >
> >France
> >
> >.
> >
>