Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5700 Views
- Getit, ivan, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is row-level compre?
Can we use where clause in union?
Write a sql query to delete duplicate records from a table called table1
Explain the steps to use transact-sql cursor?
How do you set a trace flag in sql server?
What is merge replication?
What is acid db?
What is the difference between a view and a stored procedure?
What is compound operators?
Explain partitioned view?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How to optimize stored procedures in sql server?
What is the function of sql server agent windows service?
What is SQL Azure Firewall?
How to insert multiple rows with a subquery?
