Interested to Buy Any Domain ? << Click Here >> for more details...
How to work on DTS?what is the main requirement?
- 1 Answers
- 5775 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 deploy, process and build? : sql server analysis services, ssas
How to retrieve field values using mssql_result()?
Do you know query execution plan?
Can another user execute your local temporary stored procedures?
Explain the relational database management system (rdbms)?
What is the maximum number of index per table?
Explain different types of locks in sql server.
Can multiple columns be used in sql group by clause in ms sql server?
Where do you find the default Index fill factor and how to change it?
What does the update command do?
What is inline table-value user-defined function?
What are alternate keys?
What are the different types of replication you can set up in sql server?
What is the use of keyword with encryption.
Ways to improve the performance of a SQL Azure Database?
