I want to ask the following:
Does anyone have an example of some code which executes an SSIS package from a ASP.NET web app using VB.NET?
I have built a web application and want to be able to execute the SSIS package when the user clicks a button on the web page.
So far I have:
Dim app As New Application
Dim PkgName As New Package
PkgName = app.LoadPackage(strPackagePathName, Nothing)
app.PackagePassword = strSSISPassword
Dim execResult = New DTSExecResult()
execResult = PkgName.Execute()
What I know is that this does not work from a client's desktop as the above code executes the package locally and it needs to be exectuted remotely. It does work if I execute it from the server.
I need to know how to set this up so it runs remotely. I have searched MSDN (useless), codeproject.com and sqlservercentral. No luck.
View Complete Post