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 |
How can you control the amount of free space in your index pages?
What is the command used to recompile the stored procedure at run time?
What is transaction server explicit transaction?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is difference between inner join and full join?
What is difference between Datepart() and Datename() in SqlServer?
Distinguish between commit and rollback?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How do you check sql server is up and running?
How to use subqueries with the in operators in ms sql server?
Is it possible in sql table to have more than one foreign key?
Why SQL Agent is used?
Oracle (3253)
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)