Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DTS and SSIS?
- 3 Answers
- 37258 Views
- Allianz, I also Faced
- E-Mail Answers
Answer Posted / maddy
Hi,
The DTS and SSIS are both used in SQL Server
Transformations. Th e DTS was used for transformation
purpose upto SQL Server 2000 and SSIS (Including SSAS and
SSRS) are the advanced to DTS and are included in SQL Server
2005 onwards. The capability of SSIS tool in comparison with
DTS is tremendous. This SSIS tool is in competition with
other ETL Tools in the present.The SSIS has lot added
features as per the current requirements.
| Is This Answer Correct ? | 22 Yes | 12 No |
Post New Answer View All Answers
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What are the requirements on sql server network connections?
Why can there be only one clustered index and not more than one?
What is raid and what are different types of raid levels?
What are the restrictions that views have to follow? : SQL Server Architecture
What are the different authentication modes in sql server?
What is meant by Active-Passive and Active-Active clustering setup?
How to resolve the orphan use problem? : sql server security
Why SQL Agent is used?
What is resource governor in sql server?
What are the differences between triggers and stored procedures?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is store procedure? How do they work?
What is #table in sql server?
What happens if date-only values are provided as date and time literals?
