///通过SSIS包 将数据导入数据库//dtsx文件名///csv文件名///protectedboolFillData2DB(stringdtsxFileName,stringcsvFileName)
{stringdtsxFile=System.AppDomain.CurrentDomain.BaseDirectory+"DTSX\\"+dtsxFileName;
Microsoft.SqlServer.Dts.Runtime.Wrapper.Application app=newMicrosoft.SqlServer.Dts.Runtime.Wrapper.Application();//Call the dtsx fileIDTSPackage90 package=app.LoadPackage(dtsxFile,true,null);//另外还有一种方法叫LoadFromSQLServerpackage.Connections["File"].ConnectionString=Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, csvFileName);
package.Connections["本地连接"].ConnectionString=ConfigurationSettings.AppSettings["ConnStr"];
DTSExecResult result=package.Execute();//获取包的执行信息//string message = string.Empty;//if (result.Equals(DTSExecResult.DTSER_FAILURE))//{//for (int i = 0; i
}