How to work on DTS?what is the main requirement?
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
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How to optimize stored procedure optimization?
What is user-defined scalar function?
What do you mean by cardinality?
Explain encryption of entire databases without the need for application changes in sql server 2008?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
If the job running very slow what is the action you do
What is difference between join and natural join?
how you can list all the tables in a database?
What is etl - extraction, transformation, and loading?
Mention the differences between substr and charindex in sql server.
How to copy data from one table to another table?
How to access the inserted record of an event?
What is attribute hierarchy? : sql server analysis services, ssas
Is it possible to update the views? If yes, how, if not, why?