求救啊!请问在asp.net中(我用的C#.net)中怎么调用DTS,

[刘明金]

请问在asp.net程序中(我用的C#.net)中怎么调用DTS,最好有原程序.

[jarry_hu]

/// <summary>
/// 运行DTS（Data Transformation Services ）
/// </summary>
/// <returns></returns>
public string runDTS()
{
try
{
string returnValue;
DTS.Package2Class package = new Microsoft.SqlServer.DTSPkg80.Package2Class();
string fileName = "C:\\DTStest.dts";
string password = null;
string packageID = null;
string versionID = null;
string name = "DTStest";
object pVerpersistStfOfHost = null;
package.LoadFromStorageFile(fileName,password,packageID,versionID,name,ref pVerpersistStfOfHost);

package.Execute();
package.UnInitialize();
package=null;
returnValue = "success";
return returnValue;

}
catch(Exception ex)
{
throw ex;
}

}

楼主如果还有什么迷惑，可以联系我：MSN：[e-mail]