Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5789 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 |
How do you open a cluster administrator?
What is indexing explain it with an example?
How connect excel to sql server?
How to delete existing rows in a table?
What is the importance of a recovery model?
List the different types of joins?
What is difference between rollback immediate and with no_wait during alter database?
What is the difference between Triggers and Stored Procedure?
What is implicit mode in sql server?
Define full outer join?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How network traffic be reduced by using the stored procedure?
-
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)
