March 2007
Beginner to intermediate
88 pages
1h 52m
English
Content preview from SQL Server Integration Services
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Installation and Setup
Follow the instructions that ship with SQL Server to install SSIS in your environment. The examples in this book assume that the SQL Server installation is on the local computer with default configuration. The examples also assume that the login account has administrative permissions on the local computer.
Use SQL Server Configuration Manager—a tool used to manage services associated with SQL Server—to ensure that SQL Server and SQL Server Integration Services are running.
Start Configuration Manager by selecting All Programs → Microsoft SQL Server 2005 → Configuration Tools → SQL Server Configuration Manager from the Start menu. Select the SQL Server 2005 services node in the left pane to view the state of each SQL Server 2005 Service, as shown in the following figure.
Figure 3. SQL Server Configuration Manager