SQL Server Integration ServicesSQL Server Integration Services

如需舊版 SQL Server 的相關內容,請參閱 SQL Server Integration ServicesFor content related to previous versions of SQL Server, see SQL Server Integration Services.

MicrosoftMicrosoft Integration ServicesIntegration Services 是可建立企業級資料整合和資料轉換方案的平台。 Integration ServicesIntegration Services is a platform for building enterprise-level data integration and data transformations solutions. 您可利用下列方式使用 Integration ServicesIntegration Services 解決複雜的商務問題:複製或下載檔案、傳送電子郵件訊息以回應事件、更新資料倉儲、清理和採礦資料,以及管理 SQL ServerSQL Server 物件和資料。You use Integration ServicesIntegration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL ServerSQL Server objects and data. 這些封裝可單獨使用或搭配其他封裝使用,以因應複雜的商務需求。The packages can work alone or in concert with other packages to address complex business needs. Integration ServicesIntegration Services 可從各種來源 (如 XML 資料檔案、一般檔案與關聯式資料來源) 擷取與轉換資料,然後再將該資料載入一個或多個目的地。 can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Integration ServicesIntegration Services 包含一組豐富的內建工作和轉換;建構封裝的工具;以及執行和管理封裝的 Integration ServicesIntegration Services 服務。 includes a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration ServicesIntegration Services service for running and managing packages. 您可使用 Integration ServicesIntegration Services 圖形工具建立方案,而不需要撰寫任何程式碼;或者,您也可以撰寫擴充 Integration ServicesIntegration Services 物件模型,以程式設計方式建立封裝及撰寫自訂工作和其他封裝物件。You can use the graphical Integration ServicesIntegration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration ServicesIntegration Services object model to create packages programmatically and code custom tasks and other package objects.

嘗試 SQL Server 和 SQL Server Integration ServicesTry SQL Server and SQL Server Integration Services

info_tip 取得說明Get Help