Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5655 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
Explain temporary table vs table variable by using cursor alternative?
Explain what is sql server english query?
Do you know what are acid properties of transaction?
What is the use of stored procedure?
how to use DTS package in 2000,2005,2008 in sql server
Write a code to select distinct records without using the DISTINCT keyword.
How to create a user to access a database in ms sql server using "create user" statements?
What are window functions in sql server?
What happens if you insert a duplicate key for the primary key column in ms sql server?
Can we install sql server 2016 on windows 7?
What is sql collation?
What are the database roles? : sql server security
What are the properties of the transactions?
Explain try...catch with sql server?
Can two tables have the same primary key?
