Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5790 Views
- Getit, ivan, I also Faced
- E-Mail Answers
Answer / naresh
DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a database table?
what's the difference between a primary key and a unique key? : Sql server database administration
What is table constraint?
What are some examples of schemas?
what is difference between nchar and char in Sql server ?
How to create view in stored procedure sql server?
What are the different ways of moving data/databases between servers and databases in SQL Server?
What is the cartesian product of table?
How to determine the service pack currently installed on SQL Server?
What are different types of raid levels?
How can you see what type of locks used?
Explain what is the function of sql server agent windows service?
-
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)
