基于数据转换服务实现卷烟吸阻达标率的计算

Achieve Compliance Ratio of Cigarette Draw Resistance Calculation Based on Data Transformation Service

针对吸阻达标率计算过程复杂,操作步骤繁多的问题,提出运用SQL Server工具DTS(Data Transformation Service数据转换服务)计算卷烟吸阻达标率,其实现过程包括数据库连接、数据表建立、视图创建、DTS包设计、代码编写、JOB作业建立和Excel透视表建立等步骤。结果证明吸阻达标率计算程序的开发不仅为达标率的实际应用提供技术支撑,还有助于企业更好地控制产品质量,提高生产工艺水平。

Aiming at the probIems of caIcuIating compIiance ratio of cigarette draw resistance,such as compIicated process and many steps,SQL Server tooI,DTS （Data Transformation Service）,is used to caIcuIate compIiance ratio of cigarette draw resis-tance.The whoIe process incIudes the foI owing steps,database connectivity,data tabIes creation,view creation,DTS package design and coding,JOB operation,ExceI PivotTabIes creation and so on. The program deveIopment not onIy provides techni-caI support for practicaI appIication of cigarette draw resistance compIiance ratio but aIso heIps to better controI product quaIity,improve production technoIogy IeveI.