DTS包括()部分。A、时间戳产生的过程B、需加时间戳的文件摘要C、DTS收到文件的日期和时间D、DTS的数字签名
DTS包括()部分。
- A、时间戳产生的过程
- B、需加时间戳的文件摘要
- C、DTS收到文件的日期和时间
- D、DTS的数字签名
相关考题:
You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)A.Save the DTS package so that it has an owner password.B.Save the DTS package so that it has a user password.C.Encrypt the DTS package details in the command line of the dtsrun utility.D.Store the DTS package in the Meta. Data Services repository.E.Store the DTS package as a Microsoft Visual Basic file.
You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A.Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B.Modify the workflow in the DTS package so that the server in Sydney is included.C.On the server in Sydney, install an OLE DB provider for the mainframe. database.D.On the server in Sydney, delete and then re-create the DTS package.
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.What should you do?A.Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.B.Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.C.Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.D.Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.
SQL Server 2000提供了数据转换服务(DTS),利用DTS可以实现不同数据源之间的数据转换与传输。关于DTS的功能,下列说法正确的是A.DTS可以帮助用户方便、快捷地实现数据的导入和导出操作。但DTS只支持SQL Server 2000数据库之间的导入和导出B.利用DTS传输数据时,用户不能只传输一个表的部分数据,而必须传输整个表的数据C.利用DTS传输数据时,可以将数据传输到其他数据库服务器上,而且在传输过程中可以在目标服务器上建立新表,并将数据传输到新表中D.利用DTS在不同数据库间传输数据时,SQL Server并不对执行传输操作的用户进行权限认证。因此,用户可利用DTS传输数据库中的任何数据
DMS的主要功能是()。A.SCADA/AGC/PAS, B.SCADA/AGC/EDC/DTS5C.SCADA/LM/PAS/(AM/FM/GIS); D.SCADA/LM/PAS/DTS。
下列关于DTS数据转换的叙述中,正确的是()。A、DTS转换是在数据到达目的之后应用于一块数据的一个或多个函数或操作B、源数据会改变C、DTS可以操纵列数据,包括更改列的类型、大小、小数位数或为空型等D、DTS只能将文本文件转换为SQL Server数据表
关于DM迁移工具DTS说法错误的是()A、DM数据迁移工具DTS可跨平台实现数据库之间的数据和结构互导B、DTS可实现DM数据库与文本文件之间的数据或者结构互导C、DTS无法支持迁移过程中的数据类型转换D、在迁移的过程中它最大限度地保留了源数据的原始信息
问答题简述DTS的过程。