Đang chuẩn bị liên kết để tải về tài liệu:
MASTERING SQL SERVER 2000- P17

Tham khảo tài liệu 'mastering sql server 2000- p17', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 820 I CHAPTER 22 DATA TRANSFORMATION SERVICES Launching the Wizards There are many ways to launch the DTS Wizards. To launch the DTS Wizards from within SQL Server Enterprise Manager follow these steps 1. Select any node in the treeview at or below the level of a SQL Server. 2. Choose Tools Data Transformation Services Import Data to launch the DTS Import Wizard or Tools Data Transformation Services Export Data to launch the DTS Export Wizard. Alternatively you can launch the DTS Wizards from the Select Wizard dialog box by following these steps 1. Select any node in the treeview at or below the level of a SQL Server. 2. Choose Tools Wizards or click the Run a Wizard button on the toolbar. Either of these actions will open the Select Wizard dialog box. 3. Expand the Data Transformation Services node in the dialog box. 4. Choose DTS Export Wizard or DTS Import Wizard. 5. Click OK to launch the Wizard you ve chosen. You can also launch the DTS Wizards from the Data Transformation Services node in SQL Server Enterprise Manager 1. Select the Data Transformation Services node under any server name in the treeview. 2. Select Action All Tasks Import Data to launch the DTS Import Wizard or Action All Tasks Export Data to launch the DTS Export Wizard. Alternatively you can right-click the Data Transformation Services node and choose All Tasks Import Data to launch the DTS Import Wizard or All Tasks Export Data to launch the DTS Export Wizard. To launch the DTS Wizard from the Windows Start menu choose Start Programs Microsoft SQL Server Import and Export Data. Finally you can launch the DTS Wizards directly from the Windows command prompt. The simplest way to do so is just to type or run from a batch file the name of the launcher program dtswiz If entered with no options this will have the same effect as choosing the Import and Export Data menu item from the Start menu. Optionally you can supply a number of arguments to the dtswiz program. Table 22.1 lists the command line