Abstract: In the background of coal mine, this paper analyzed, designed and implemented a kind of data extraction program triggered by data sources, with DTS tool and.NET remote architecture. The program can load data sources distributd in different places to data warehouse, and considered system failure and network failure during extracting data. It has higher robustness.