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 an indexed view?
how to find number of columns in a table in sql server 2000 and 2005 also
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
What is a job?
what is raid and what are different types of raid configurations? : Sql server database administration
What is master database? : SQL Server Architecture
What is default constraint in ms sql server?
Tell me can we use custom code in ssrs?
What is subquery explain with example?
What is the sql server 2000 version number?
Do you know spatial data types - geometry and geography in sql server 2008?
What is the difference between char and varchar2 datatype in sql?
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)