471,058 Members | 995 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,058 software developers and data experts.

Execute SSIS package from a Button

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
Jun 27 '08 #1
2 3194
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
Jun 27 '08 #2
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/lib...(printer).aspx
http://msdn2.microsoft.com/en-us/lib...(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

Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by =?Utf-8?B?THVpZ2k=?= | last post: by
3 posts views Thread by =?Utf-8?B?THVpZ2k=?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.