what is DTS what are tasks available
Answer / seshagiri
DTS is set of graphical tools and programmable objects,
using that we can extract,transform, and consolidate data
from source in to multiple destinations.
Tasks are....
Transform Data
Copy and Manage Data
Function as Jobs
| Is This Answer Correct ? | 1 Yes | 0 No |
What is row_number () and partition by in sql server?
Can you pass expressions to function parameters?
What do you mean by subquery?
How to insert new line characters into strings?
When columns are added to existing tables, what do they initially contain?
How can you set the threshold at which sql server will generate keysets asynchronously?
What are the difference between primary key and unique key? : sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What are xml indexes?
How to compare the top two records using sql?
How to list all tables having unique constraints in any of the columns in a database.
Why normalization is used?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)