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

do the same with SSIS

-- bruce (sqlwork.com)


"pvong" wrote:

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

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

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


"bruce barker" wrote:

> do the same with SSIS
>
> -- bruce (sqlwork.com)
>
>
> "pvong" wrote:
>
> > 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
> >
> >
> >