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 will you find out if there are expensive SQL statements running or not?
What is the default fill factor value?
What is rtm version in sql server?
What is difference beteen Migration and Upgrdation?
explain different types of constraints? : Sql server database administration
Different types of keys in SQL?
What is the need for group functions in sql?
Explain time data type in sal server 2008?
How to get max 100 values from sql server
How to create a stored procedure with a statement block in ms sql server?
What are key constraints?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
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)