Execute SSIS package from a Button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pvong - 14 Apr 2008 16:43 GMT

I'm new to SSIS. Can someone point me in the right direction on how to
execute an SSIS package from a button OnClick?

With DTS in SQL2000, I just created a job that ran the DTS package and then
ran the job from a Stored Procedure.

Thanks!
Phil

Reply to this Message

bruce barker - 14 Apr 2008 16:46 GMT

do the same with SSIS

-- bruce (sqlwork.com)

> I'm new to SSIS. Can someone point me in the right direction on how to
> execute an SSIS package from a button OnClick?
[quoted text clipped - 4 lines]
> Thanks!
> Phil

Reply to this Message

Misbah Arefin - 14 Apr 2008 23:34 GMT

you can run the package from file, via a sql job on remote machine, or
directly from the remote sqlserver - good examples at
http://msdn2.microsoft.com/en-us/library/ms403355.aspx

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).aspx
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtsexec
result(printer).aspx

Signature

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

> do the same with SSIS
>
[quoted text clipped - 8 lines]
> > Thanks!
> > Phil

Reply to this Message

Execute SSIS package from a Button

Free Magazines