Database Reference
In-Depth Information
Preparing and installing SQL Server
Integration Services
The first release of Integration Services in SQL Server 2005 has changed the ETL functionality
for SQL Server. It is a successor to SQL Server 2000 version's Data Transformation Services
(DTS), and took a significant step forward by providing more intuitive designers, but also
a native .NET execution environment. SQL Server 2008 R2 maintains that process with a
significant scalability improvement in data pipeline and data warehouse enhancements such
as persistent lookups. The SSIS enhancements from SQL Server 2008 R2 are improved
scripting experience, data profiling task, an enhanced ADO.NET destination adapter, which
also includes an option of Use bulk insert when available to improve the performance of
bulk insert operations, improved data flow lookup, component with enhanced performance,
and caching for Lookup transformation. The development tool for SSIS is Visual Studio 2008
development and in short BIDS too. BI Development Studio is an all-in-one tool, which has
a built-in Visual Studio infrastructure that provides a powerful and flexible development
environment for SSIS, SSAS, SSRS, and other .NET related programming languages.
In this recipe, we will evaluate the SQL Server Integration Services installation options and
best practice hardware/software requirements, configuration, and security considerations for
the installation.
Getting ready
In order to prepare for the installation of SQL Server Integration Services, you will need to
ensure you have the following in place:
F
The.NET framework 3.5 SP1, Windows Install 4.5, and SQL Server setup support files
are still applicable to Integration Services installation
F
For more information on the prerequisite files required, refer to the recipe,
Adding
features
of
SQL
Server
2008
R2
using
Slipstream
technology
in
Chapter
1
:
Getting
Started
with
SQL
Server
2008
R2
How to do it...
By default, all the SQL Server services can be installed using the installation media,
best practice is to copy all the files to the local drive of that server for quick and efficient
setup completion:
1.
From the
root
folder of the installation media, double-click
Setup.exe
.
2.
When the prerequisites are installed, the Installation Wizard runs the SQL Server
Installation Center.
Search WWH ::
Custom Search