You need to ensure that the following requirements are met: • The first row of the file contains the first row of dat• a

HOTSPOT
You administer a Microsoft SQL Server 2012 database.
The database contains a table that has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and
Export Wizard.
You need to ensure that the following requirements are met:
• The first row of the file contains the first row of dat• a.
• Each record is of the same length.
• The date follows the U.S. date format.
• The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

HOTSPOT
You administer a Microsoft SQL Server 2012 database.
The database contains a table that has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and
Export Wizard.
You need to ensure that the following requirements are met:
• The first row of the file contains the first row of dat• a.
• Each record is of the same length.
• The date follows the U.S. date format.
• The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Answer:

Explanation:
http://msdn.microsoft.com/en-us/library/ms178804.aspx
http://msdn.microsoft.com/en-us/library/ms187828.aspx



Leave a Reply 5

Your email address will not be published. Required fields are marked *


siddique

siddique

The answer is wrong.
Check Unicode ad changed the format to fixed rather than delimited

dennis

dennis

Yep, you are right

Edouard

Edouard

And uncheck “Column names in the first row of data”

MKL

MKL

It should be change the format and uncheck “Column name in the first row of data”

jzed

jzed

isnt delimited?