Execute SSIS Package from aspx page (2.0)

[=?Utf-8?B?THVpZ2k=?=]

Hi all,
how can I execute a SSIS Package from an aspx page in C#?
I'm using .NET 2.0.

Thanks a lot.

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

[=?Utf-8?B?TWlzYmFoIEFyZWZpbg==?=]

To run remote packages from a local computer that does not have Integration
Services installed, start the packages so that they run on the remote
computer on which Integration Services is installed. You do this by having
the local computer use SQL Server Agent, a Web service, or a remote component
to start the packages on the remote computer. If you try to start the remote
packages directly from the local computer, the packages will load onto and
try to run from the local computer. If the local computer does not have
Integration Services installed, the packages will not run.

http://msdn2.microsoft.com/en-us/library/ms403355.aspx
--
Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin
"Luigi" wrote:

Hi all,
how can I execute a SSIS Package from an aspx page in C#?
I'm using .NET 2.0.

Thanks a lot.

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

[=?Utf-8?B?YnJ1Y2UgYmFya2Vy?=]

make a sqlagent job to run the package. set the job to run manually, then use
the sp sp_start_job to run the package.

-- bruce (sqlwork.com)
"Luigi" wrote:

Hi all,
how can I execute a SSIS Package from an aspx page in C#?
I'm using .NET 2.0.

Thanks a lot.

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

[=?Utf-8?B?THVpZ2k=?=]

Thank you all.
Now I'm reading the article from MSDN Library to understand how to intercept
if the package fails.

http://msdn2.microsoft.com/en-us/lib...(printer).aspx

Luigi