How can I execute a DTS package from an asp.net page?
I found the code below online, and altough it throws no errors, it doesnt
execute the dts package either?
What am i missing?
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;
this.iptFile.PostedFile.SaveAs("C://temp//test.xls");
package.LoadFromSQLServer(
"SERVER",
"sa",
null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,
null,
null,
null,
"dtsTest",
ref pVarPersistStgOfHost);
package.Execute();
package.UnInitialize();
System.Runtime.InteropServices.Marshal.ReleaseComO bject(package);
package = null;
thanks