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 denormalization? : Sql server database administration
What is difference between temp table and cte?
Explain what is meant by replication of database?
What is the syntax to execute the sys.dm_db_missing_index_details?
How can I tell if sql server is 32 or 64 bit?
Define the term DML, DDL and DTL?
What is a coalesce function?
How to add a new dsn with the odbc driver for sql server?
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
How to defragment table indexes?
How to make remote connection in database?
How to insert data into an existing table?
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)