The Article first introduces the system architecture of ETL , clarifying the merit of "data transmission subsystem " in "Grasped Migration Data acquisition system" Project choosing the ETL tool to realize data extract work. Then, Discussing the essential technology of constructing data extract package --DTS Programming technology .Then, unifying application system—"data transmission subsystem" in "Grasped Migration Data acquisition system" Project which I develops, The Article exhaustively discusses the Metadata database design and how I uses DTS Programing Technical realizing the data extract package of ETL tool. Finally, narration needed improved place of the system. |