使用VS.NET2003操作SQLServer DTS.

96 阅读 0 评论 64 点赞

我是靠谱客的博主爱笑枕头，这篇文章主要介绍使用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;