Extracting, Transforming, and Loading (ETL) are key processes for any data management. ETL activities include an import and export of data from various data sources into an SQL Server table format. The data volume will vary from one row to billions of rows. To handle such import/export active ETL operations, a tool is essential. SQL Server Business Intelligence tools provide a strong foundation by the way of services (SSA) & tools (BIDS).
SQL Server provides many processes for the ETL management, such as BCP (Bulk Copy), BI (Bulk Insert), DTS (Data Transformation Services) and SSIS (SQL Server Integration Services). Since SQL Server 2005 DTS has been transformed into SSIS, which is a step ahead in terms of functionality providing more intuitive design and management for ETL operations, henceforth DTS functionality has been discontinued. SQL Server 2008 and SQL Server 2008 R2 enhances the native .NET execution environment to continue...