The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P82: 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. | ETL Techniques Chapter 8 387 Exam Objectives Frequently Asked Questions Q When I use BCP to export data to a csv file the column names are not shown in the header row. Is there a way to do this A No BCP does not support exporting to data files with a header row. You can import from a file with a header row however by using the -F switch to skip the first row. Q I need to create a format file for my import to work. Should I use a non-XML format file or an XML format file A If you need to maintain compatibility with an older version of BCP you should use a non-XML format file. Otherwise the XML format files are often easier to work with and they are the new format file type. Q When I open my source file in notepad I can see the data. There are spaces between the letters but it is readable. However when I try to import the data BCP fails. What might be the problem A The source data file is likely a Unicode data file. Try running the BCP import command with the -w command argument to specify a Unicode file type. Q I want to write a report that shows data from both SQL Server and Oracle in a single query. Should I use the ad hoc query functions or create a linked server A If this is a report that will be long running not just a onetime deal then you should create a Linked Server to run the report against. Q I use Oracle s syntax when I query my Oracle instance using a linked server. However when I try to enter that syntax in SSMS I get errors. What should I do A To use Oracle s own syntax you need to send it using a pass-through query. The OPENQUERY function allows you to submit a query to be processed by the remote instance. 388 Chapter 8 ETL Techniques Q While trying to run a distributed transaction across to SQL Server instances I receive an error with the number 8501 stating that the MSDTC on server . is unavailable . What do I need to do to fix the problem A Distributed transactions between two SQL Server instances on separate machines require each machine to have
