题目内容

You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.
The destination table is configured as shown in the exhibit.
You want to load the data into the table as quickly as possible. What should you do？

A. Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.
B. Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.
C. Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.
D. Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.

查看答案

搜索结果不匹配？点我反馈

更多问题

有以下程序： main() { char str[]="xyz", ps=str; while(ps) ps++; for(ps--;ps-str＞=O;ps--) puts(ps); } 执行后的输出结果是()。

A. yz xyz
B. z yz
C. z yz xyz
D. x xy xyz

查看答案

根据《关于开展重大危险源监督管理工作的指导意见》，下列场所或装置属于重大危险源申报登记范围的是()。

A. 某化工厂生产场所临时存放2个4.5t煤油储罐(临界量为10t)
B. 某工厂储罐区存有3个2t乙炔储罐(临界量为10t)
C. 某烟花爆竹厂生产场所临时存放0.1t黑火药、0.1t烟火药、0.1t爆竹、0.1t烟花(临界量均为0.5t)
D. 额定蒸汽压力＞2.5MPa，且额定蒸发量＞10t/L的蒸汽锅炉

查看答案

按投资基金能否赎回，可将其分为封闭型投资基金和开放型投资基金两种类型。()

A. 正确
B. 错误

查看答案

小儿疳积的针灸治则是

查看答案

有以下程序： main() { char str[]="xyz", *ps=str; while(*ps) ps++; for(ps--;ps-str＞=O;ps--) puts(ps); } 执行后的输出结果是()。

根据《关于开展重大危险源监督管理工作的指导意见》，下列场所或装置属于重大危险源申报登记范围的是()。

按投资基金能否赎回，可将其分为封闭型投资基金和开放型投资基金两种类型。()

小儿疳积的针灸治则是

有以下程序： main() { char str[]="xyz", ps=str; while(ps) ps++; for(ps--;ps-str＞=O;ps--) puts(ps); } 执行后的输出结果是()。