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
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to download and install microsoft sql server management studio express?
How to use union to merge outputs from two queries together in ms sql server?
Determine when an index is appropriate?
Explain cdc and sql injection?
Why are views required in the sql server or in any other database?
How to add an address record into adventureworkslt?
What are the differences between DDL, DML and DCL in SQL?
How you can get the list of largest tables in a database?
How will you know when statistics on a table are obsolete?
What are diverse clauses that form a part of sql?
Do you know what is sql service broker?
What is optimization and its types?
What is built-in function?
What is wide table?