DTS.Application App=new DTS.Application();
try
{
DTS.PackageSQLServer package= App.GetPackageSQLServer("(local)\\CaaZJ", "jhd", "123", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default);
DTS.PackageInfos Infos; Infos = package.EnumPackageInfos("", false, ""); foreach(DTS.PackageInfo Info in Infos) { Console.WriteLine("Name : {0}\tVersionID : {1}",Info.Name,Info.VersionID); }
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
Console.Read();
try
{
DTS.PackageSQLServer package= App.GetPackageSQLServer("(local)\\CaaZJ", "jhd", "123", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default);
DTS.PackageInfos Infos; Infos = package.EnumPackageInfos("", false, ""); foreach(DTS.PackageInfo Info in Infos) { Console.WriteLine("Name : {0}\tVersionID : {1}",Info.Name,Info.VersionID); }
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
Console.Read();
解决方案 »
- 【EF 更新不了数据 求助】
- 一个winform问题
- 从数据读取信息时候遇到了'必须声明变量'的问题
- VS2005里面如何实现文件的下载功能 在线急等`````
- 急 ~~~.net 2005(c#)在windows xp下作的安装包 安装到windows server 2003 失败
- 请教treeview的selectednodechange事件怎样才能不触发同时取得node节点值?
- 一个小小小的C#问题
- 关于继承中方法重写的问题。
- DateGrid问题!
- 拔完牙,好痛,散分1000 (2)
- 请各位给我一些数据加密的入门文章和算法解析,谢谢!
- ExecuteNonQuery问题,有的机子上执行成功,有的不行??
但是下面得问题我知道怎么搞得!!
/// <summary>
/// DTS包
/// </summary>
/// <param name="strServerName">服务器</param>
/// <param name="strUserName">用户名</param>
/// <param name="strUserPwd">用户密码</param>
/// <param name="packagePath">DTS包路径</param>
public static void DTSTranf(string strServerName,string strUserName,string strUserPwd)
{ string packagePath = System.Windows.Forms.Application.StartupPath + @"\" + "DTSTansfer.dts";
DTS.Package2Class package=new DTS.Package2Class();
DTS.Application app = new DTS.ApplicationClass();
object MIA=System.Reflection.Missing.Value;
try
{
DTS.SavedPackageInfos Infos = package.GetSavedPackageInfos(packagePath);
string packageid = Infos.Item(1).PackageID.ToString(); //DTS ID
string versionid = Infos.Item(1).VersionID.ToString(); //DTS 版本号
string packageName = Infos.Item(1).PackageName.ToString(); //DTS名称 package.LoadFromSQLServer(strServerName,strUserName,strUserPwd,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,"123",packageid,versionid,packagePath,ref MIA);
package.LoadFromStorageFile(packagePath,"",packageid,versionid,packageName,ref MIA);
package.SaveToSQLServer(strServerName,strUserName,strUserPwd,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,"","","",ref MIA,false);
package.UnInitialize(); DTS.PackageSQLServer pkgSQLServer = app.GetPackageSQLServer(strServerName,strUserName,strUserPwd,DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default);
DTS.PackageInfos infos = pkgSQLServer.EnumPackageInfos(packageName,false,packageid);
if(infos.EOF)
{
MessageBox.Show("DTS导入包失败!!");
}
package.Execute(); //执行DTS包
}
catch(Exception ex)
{
throw ex;
}
finally
{
package.UnInitialize();
package=null;
}
}
下面错误信息:
未处理的“System.Runtime.InteropServices.COMException”类型的异常出现在 DataPop.exe 中。其他信息: 指定的 DTS 包('名称 = 'F:\DataPop\DataPop\bin\Debug\DTSTansfer.dts'; ID.VersionID = {4A17772D-7C73-4CE0-8264-E671DF555011}.{A3C60007-BEB7-4D81-BAE6-1F5029560AC4}')不存在。
{
DTS.Package2Class package = new DTS.Package2Class();
string fileName = @"D:\DBS_IMG\tem_image\DB_Picture.dts";
string password = null;
string packageID = null;
string versionID = null;
string name = "DB_Picture";
object pVerpersistStfOfHost = null;
package.LoadFromStorageFile(fileName,password,packageID,versionID,name,ref pVerpersistStfOfHost);
package.Execute();
package.UnInitialize();
package=null;
}