The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P81: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 382 Chapter 8 ETL Techniques EXERCISE Executing an SSIS Package In this exercise you will use the DTExecUI utility to execute the package that you created in Exercise using the Import and Export Wizard. This exercise assumes that you have administrative privileges on the SQL Server instance that you are working with that you have the AdventureWorks2008 sample database installed on your SQL Server instance that BIDS is installed and that you are running the exercise from the same computer where the SQL Server instance is installed. 1. Start the DTExecUI utility by clicking Start menu I Run. Enter dtexecui in the Open box. Click OK. 2. On the General page enter the following values. DO NOT click Execute yet Package Source SQL Server Server local Logon to the Server Use Windows Authentication Package Export Product Data 3. View the options on the other pages in the utility. Don t change anything yet . 4. Click Execute and watch the status as the package executes. 5. Verify that the C Wizard was just re-created check the date and time stamp . 6. Close the Package Execution Progress window by clicking Close. 7. This time when you run the package you will have it write to a different output file. Back in the Execute Package Utility select the Connection Managers page. 8. Turn on the checkbox next to the DestinationConnectionFlatFile connection manager. 9. Click into the Connection String field for the DestinationConnectionFlatFile connection manager and change the path to C Wizard . 10. Click the Execute button and again watch the execution status in the Package Execution Progress window. 11. Verify that there is now a new file at C Wizard . You successfully change the destination of the package ETL Techniques Chapter 8 383 Alternative ETL Solutions As you can see Microsoft provides a variety of methods that you can use to move data both in and out of your SQL Server instances. However there are still more ways that you .
