基于SSIS设计器的数据库数据转换的实现

Realization of Database Data-conversion Based on SSIS Designer

SSIS是一个数据集成转换的平台,它可以对数据库中的数据进行转换、提取和加载,SSIS设计器可以灵活的给SSIS包添加任务,它允许数据库管理员导入、导出数据库中的数据和从多个数据源中转换同种或异种数据,以及定义复杂数据的工作流,因此,利用SSIS设计器能够保证数据库中的较复杂数据高效、快速和合理的转换。

SSIS is a data transformation platform,it can be in the database data conversion,extracting and loading,the SSIS designer can be flexible to the SSIS package adds the task,it allows database administrators to import,export the data in the database and data from multiple source conversion of homogeneous or heterogeneous data,as well as the definition of complex data workflow,therefore,using the SSIS designer to ensure that the database more complicated data efficiently,fast and reasonable conversion