Connecting Tech Pros Worldwide Forums | Help | Site Map

Execute SSIS package from aspx page

=?Utf-8?B?THVpZ2k=?=
Guest
 
Posts: n/a
#1: Feb 6 '08
Hi all,
how can I execute an SSIS (SQL Server 2005) package from an aspx page in a
web application (.NET 2.0)?

Thanks in advance.

--
Luigi
http://blogs.dotnethell.it/ciupaz/
--
Luigi
http://blogs.dotnethell.it/ciupaz/

=?Utf-8?B?YnJ1Y2UgYmFya2Vy?=
Guest
 
Posts: n/a
#2: Feb 6 '08

re: Execute SSIS package from aspx page


the easiest is to setup a on demand sqlagent job to run the ssis package. you
start the job with the stored proc sp_start_job.

-- bruce (sqlwork.com)


"Luigi" wrote:
Quote:
Hi all,
how can I execute an SSIS (SQL Server 2005) package from an aspx page in a
web application (.NET 2.0)?
>
Thanks in advance.
>
--
Luigi
http://blogs.dotnethell.it/ciupaz/
--
Luigi
http://blogs.dotnethell.it/ciupaz/
=?Utf-8?B?THVpZ2k=?=
Guest
 
Posts: n/a
#3: Feb 7 '08

re: Execute SSIS package from aspx page


"bruce barker" wrote:
Quote:
the easiest is to setup a on demand sqlagent job to run the ssis package. you
start the job with the stored proc sp_start_job.
>
-- bruce (sqlwork.com)
Ok, I'll follow this road.
Thank you Bruce.

Luigi


Closed Thread