SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Development Forums for Programmer, Administrators and Users

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

What is the SSIS package and what does it do in SQL?

Last post 08-02-2017, 1:38 AM by florajohn225. 0 replies.
Sort Posts:
  •  08-02-2017, 1:38 AM 46684

    What is the SSIS package and what does it do in SQL?

    SSIS provides an Extract, Transform, Load (ETL) interface to SQL Server. It is comparable to competitor products like Oracle Data Integrator or IBM DataStage. It shares some functionality overlap with BizTalk (such as BizTalk's ability to take data files and load them into SQL Server), but BizTalk is a more generalized EDI tool. One of the advantages of SSIS to other ETL tools for Microsoft shops is that it is bundled with the Standard, Business Intelligence and Enterprise versions of SQL Server, lowering initial cost of ownership for the product.
View as RSS news feed in XML
Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems