Execute SSIS Package from aspx page (2.0)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luigi - 07 Mar 2008 09:53 GMT

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

Thanks a lot.

Signature

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

Reply to this Message

Misbah Arefin - 07 Mar 2008 13:21 GMT

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

Signature

Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin

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

Reply to this Message

Luigi - 10 Mar 2008 12:30 GMT

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/library/ms403355(printer).aspx

Luigi

Reply to this Message

Luigi - 10 Mar 2008 12:49 GMT

With the example of the MSDN document, I can know if the job has started
successfully, but not if the package fails for every kind of problem.
Is it possible to know also this item?

Thanks.

Luigi

Reply to this Message

Misbah Arefin - 10 Mar 2008 17:06 GMT

the Package.Execute() returns a DTSExecResult enum... in case of any error
the Execute method will return DTSExecResult.Failure

http://msdn2.microsoft.com/en-us/library/ms190901(printer).asp
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtsexec
result(printer).aspx

hope this helps

Signature

Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin

> With the example of the MSDN document, I can know if the job has started
> successfully, but not if the package fails for every kind of problem.
[quoted text clipped - 3 lines]
>
> Luigi

Reply to this Message

Luigi - 13 Mar 2008 15:50 GMT

> the Package.Execute() returns a DTSExecResult enum... in case of any error
> the Execute method will return DTSExecResult.Failure
[quoted text clipped - 3 lines]
>
> hope this helps

Thank you for the links Misbah, but this code is useful (I think) only for
.NET Framework 1.X, not for 2.0 version, because there is not the namespace:

using Microsoft.SqlServer.Dts.Runtime;

in Visual Studio 2005.
How can I solve this problem?

Luigi

Reply to this Message

Misbah Arefin - 13 Mar 2008 18:13 GMT

no it is not 1.x specific you just need to add a reference for this DLL in
your project
C:\Program Files\Microsoft SQL
Server\9.0\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll

Signature

Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin

> > the Package.Execute() returns a DTSExecResult enum... in case of any error
> > the Execute method will return DTSExecResult.Failure
[quoted text clipped - 13 lines]
>
> Luigi

Reply to this Message

bruce barker - 07 Mar 2008 16:38 GMT

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)

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

Reply to this Message

Rate this thread:

Execute SSIS Package from aspx page (2.0)

Free Magazines