The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P77: 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. | 362 Chapter 8 ETL Techniques writing a query to extract specific data from the source. Of course to write a query the source must support queries when the source has multiple tables or support queries. If you are pulling from a flat file like a .csv file you can get only the data that is in the file. If however you were importing data from another SQL Server you could select one or more tables or views or write a query to pull just the data you want. The paths you can take through the wizard vary greatly with the data sources and destinations you choose. The general flow however is 1. Launch the Wizard. You can Launch the wizard by clicking the Start menu All Programs Microsoft SQL Server 2008 Import and Export Data. You can also run or right click a database in SSMS s Object Explorer and choose Tasks Import Data. or Tasks Export Data. 2. Choose a Data Source. You can use the wizard to import data from flat files Excel files Access databases or any database that you can access via an ODBC OLE DB or .Net provider. Each provider will need to be configured differently. You will need to have the information that your selected data source requires. For example if you were pulling from a flat file you would need to know the path of the file how it was delimited comma tab etc. and whether or not there was a header row etc. You can also configure the data source. For example if the source is a flat file you can use the Advanced page to set appropriate data types for the fields in the text file. 3. Choose a Data Destination. Just like the data source this could be a flat file Excel files Access databases or some backend database you connect to using ODBC OLE DB or .Net providers. Again you will configure the destination provider according to the properties of your target. You can then also configure the destination. For example if the destination is SQL Server you can choose which database to import data into or you can even create a new database by using the
