Expand the Tables item to verify that there are no tables currently in your test database. ssis002 1Ģ Verify that your database is listed in SQL Server, as shown in Figure 3. ssis001 Figure 2: Enter the name of the database, click the OK button. Leave all of the other options set to their defaults and click the OK button. In the New Database dialog (Figure 2), enter a unique name for the database. Figure 1: Select the New Database option to create a test database in SQL Server. Right-click on the Databases item and select the New Database menu item as shown in Figure 1. In the SQL Server Management Studio, expand the server name, then expand the Databases item. Connect to the SQL Server database server that is configured for this course. When done, you will have transferred a database table from the AS/400 to SQL Server Create a new database in SQL Server Open the Microsoft SQL Server Management Studio. 1 SQL Server Integration Services (SSIS) is a set of tools that let you transfer data to and from SQL Server In this lab, you ll work with the SQL Server Business Intelligence Development Studio to develop and run a SSIS transform.
0 Comments
Leave a Reply. |