Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5701 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 the security principal at the database level that represents your session?
What is the difference between coalesce() & isnull()?
How to create a view using data from another view?
Give a example to search fr a string in all stored procedure in sql server.
Explain important index characteristics?
Distinguish between commit and rollback?
Explain what is the function of sql server agent windows service?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What's the purpose of Stored Procedure?
What is clustered primary key?
last function used in MS Access to convert sql what function will use in sql
What are the hotfixes and patches in sql server?
-
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)
