execute dts from asp.net 2.0 RSS

• • Reply
  

  fndrydotnet

  Member

  5 Points

  1 Post

  execute dts from asp.net 2.0

  May 08, 2006 11:29 PM|LINK

  I am trying to execute a dts from asp.net, but getting an error

  “The specified DTS Package ('Name = 'DTS_USERS_LIST'; ID.VersionID =  {[not specified]}.{[not specified]}') does not exist.” 
  

  I know I have saved the dts package on the sqlserver, and have run it from the server successfully.

  Here is my code:

  Package2Class package = new Package2Class();

          object pVarPersistStgOfHost = null;

  package.LoadFromSQLServer(

              sServer,

              sUID,

              sPWD,

              //DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,

              DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,

              null,

              null,

              null,

              sPkgName,

              ref pVarPersistStgOfHost);

          package.Execute();

          package.UnInitialize();

          // force Release() on COM object

          //

      System.Runtime.InteropServices.Marshal.ReleaseComObject(package);

          package = null;

   

  any inputs would be aprpeciated.

  • Moved by adec on May 08, 2006 11:54 PM