Administrating the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 72

How to do it...

There are two ways to begin designing SQL Server Agent scheduled jobs for ETL processes.

1. For the SQLExpress environment, use SQL Server Import and Export wizard and for

the server environment, use SQL Server agent.

2. There are two ways to open up the SQL Server Import and Export wizard, either

using GUI tools or command line operations. Let us do this by using the command
line operation:
Open a command prompt window with Administrative privileges and type
dtswizard.exe .

3. The file can be located within the %\program files\Microsoft SQL
Server\100\DTS\binn folder, as shown in the following screenshot:

4. From your local machine, using the Start menu point to All Programs.

5. As per the following screenshot, point to Microsoft SQL Server 2008 R2 and click

Import and Export Data.