Execute SSIS package from aspx page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luigi - 06 Feb 2008 13:20 GMT

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.

Signature

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

Reply to this Message

bruce barker - 06 Feb 2008 16:01 GMT

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)

> 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.

Reply to this Message

Luigi - 07 Feb 2008 08:00 GMT

> 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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...