Execute SSIS package from a Button

[pvong]

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

 

[bruce barker]

do the same with SSIS

-- bruce (sqlwork.com)

 

[Misbah Arefin]

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.dtsexecresult(printer).aspx