what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 13516 Views
- TCS, I also Faced
- E-Mail Answers
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
What number sorts of privileges are accessible in sql?
How do I setup a local sql server database?
Explain what is the purpose of sql profiler in sql server?
Explain “row_number()” in sql server with an example?
What is data source in connection string?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
what exactly sql injuction.how to overcome.....
Why do we use non clustered index?
How you can get a list of all the table constraints in a database?
How do you troubleshoot errors in a SQL Server Agent Job?
how you can configure a running aggregate in SSRS?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain trigger and trigger types?
What is instead of dml trigger?
Difference between DELETE and TRUNCATE?
