Last post Jul 07, 2009 06:56 AM by Jian Kang - MSFT
Jul 02, 2009 12:07 PM|Sam Solomon|LINK
I am calling my local SSIS package through an ASP.net web page. I have three buttons on my ASP.net web page. Start , Stop and Pause.
Start= Pressing Start button will actually run the Package
Stop= Pressing Stop button will stop the package in the middle if it is running
Pause= Pressing Pause will stop the package and upon pressing Start again will resume the package processing
I have the code for Start Button which is as follows:
void btnStart_Click(object sender,
pkgLocation = @"C:\Export.dtsx";
app = new Application();
pkg = app.LoadPackage(pkgLocation, null);
pkgResults = pkg.Execute();
Now I need the code for Pause and Stop button Please. Any help would be greatly appreciated.
Jul 02, 2009 02:55 PM|jagjot|LINK
check this out.
Jul 06, 2009 11:29 AM|Sam Solomon|LINK
Can some one help me on this. I am really struggling now. Please.
Jul 07, 2009 06:56 AM|Jian Kang - MSFT|LINK
From your description, I think you would like to programmatically stop a running SSIS package.
We can use a method called RunningPackage.Stop to stop the package.
There is another similar thread, please also refer to it:
As far as I know, there is no method to pause the execution of a SSIS package. I think other people may have some idea.
Running SSIS package programmatically
Running and Managing Packages Programmatically