Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5845 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 are the system database in sql server 2005?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are the disadvantages of merge replication?
What are the basic functions for master, msdb, model, tempdb databases?
Which command executes the contents of a specified file?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How many types of functions are there in sql server?
How to override dml statements with triggers?
Which command displays the SQL command in the SQL buffer, and then executes it?
How to create an inline table-valued function?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
-
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)
