what is Data Transformation Services (DTS) ?can u explain
me in detail?
Answer Posted / lakshmi
DTS is a kind of etl tool which extracts data from wide
range of sources like flatfiles,sql server,excel,oracle etc
and manipulating the data according to business logic by
using transformations before being loading into various
destinations.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What do you mean by an execution plan?
Define outer join in sql server joins?
What is log ldf?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Can you explain full-text query in sql server?
Explain data warehousing in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What are audit control procedures?
What are temporal tables in sql server 2016?
Can we shrink data file in sql server?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Do you know what is similarity and difference between truncate and delete in sql?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?