使用VS.NET2003操作SQLServer DTS.

1、新建一个项目，引用的COM组件为Microsoft DTSPackage Object Library2、操作DTS的代码如下

 A、列出所有数据库的包

 ApplicationClass app = new ApplicationClass();
 PackageSQLServer pkgSS = app.GetPackageSQLServer(SqlServerName,SqlUserName,SqlPassWord,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection);
 PackageInfos pkgInfos = pkgSS.EnumPackageInfos("",false,"");
 PackageInfo pkgInfo = pkgInfos.Next();

 txtLayOut.Text = "";

 while(!pkgInfos.EOF)
 {
  txtLayOut.Text += pkgInfo.Name + "/r/n";
  pkgInfo = pkgInfos.Next();
 }

 app = null;

 B、执行一个指定的包

 Package2Class pkg2 = new Package2Class();
 object pVarPersistStgOfHost = null;
 pkg2.LoadFromSQLServer(SqlServerName,SqlUserName,SqlPassWord,
    DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null,
    null, null, "dtsTest2", ref pVarPersistStgOfHost);

 pkg2.Execute();
 pkg2.UnInitialize();
 pkg2 = null;

 C、新增一个包

 Package2Class pkg2 = new Package2Class();
 pkg2.Name = "dtsTest3";
 object pVarPersistStgOfHost = null;
 pkg2.SaveToSQLServer(SqlServerName,SqlUserName,SqlPassWord,     
    DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection, null, null, null,     
    ref pVarPersistStgOfHost, true);
      
 pkg2 = null;