trying to execute a DTS package (that loads data into a table), no errors are thrown, .. why does it not do anything?
( I set one global variable , but even if i hard code it into the package and try to run I get the same result: no errros and package is not run)
//--------------------------code begin
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;
package.LoadFromSQLServer("(local)",null, null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref pVarPersistStgOfHost);
package.GlobalVariables.Remove("gv_startDate");
package.GlobalVariables.AddGlobalVariable("gv_fordate", gvValue);
package.Execute();
package.UnInitialize();
// force Release() on COM object
System.Runtime.InteropServices.Marshal.ReleaseComObject(package);
package = null;
//code end
( I set one global variable , but even if i hard code it into the package and try to run I get the same result: no errros and package is not run)
//--------------------------code begin
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;
package.LoadFromSQLServer("(local)",null, null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref pVarPersistStgOfHost);
package.GlobalVariables.Remove("gv_startDate");
package.GlobalVariables.AddGlobalVariable("gv_fordate", gvValue);
package.Execute();
package.UnInitialize();
// force Release() on COM object
System.Runtime.InteropServices.Marshal.ReleaseComObject(package);
package = null;
//code end