How to work on DTS?what is the main requirement?
- 1 Answers
- 5086 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
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
If the job running very slow what is the action you do
What is the command used to recompile the stored procedure at run time?
Who developed sql server?
What is inline variable assignment?
Does index speed up select statements?
How do I edit a procedure in sql server?
What is raid, and how it can influence database performance?
Explain what are the authentication modes in sql server?
Explain filtered indexes?
What are the system database in sql server 2008?
Is resultset an interface?
How do I create a trace in sql server?
Explain system views?
What do you mean by an execution plan? Why is it used? How would you view it?
