Interested to Buy Any Domain ? << Click Here >> for more details...
Diffrence between DTS vs SSIS
- 2 Answers
- 7565 Views
- IBM, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
DTS: 1)it is a part of db engine service. only 32 bit architecture is supported.
2) DTS packages--->DTS wizard, DTS designer.
3) VB script is supported.
SSIS:1)SSIS is a service independent from db engine service.
2) It supports 32 and 64 bit architecture.
3) SSIS-----> SSIS wizard, SSIS designer
4) VB and c#.net is supported.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / shyamsri83
DTS-Data Trasformation Services available up to SQL Server
2000
SSIS - Sql server integration services. available from sql
server 2005. SSIS is introduced instead of DTS
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the meaning of resultset type_scroll_insensitive?
What the different components in replication and what is their use?
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
Explain sql server service broker?
find 2nd highest salary of person using cursor concept?
What is a hint?
What is data file in computer?
What is the difference between drop table and truncate table?
from the table display the 2nd highest salary? and also the least 2nd salay?
What is instead of trigger sql server?
Why should one not prefix user stored procedures with ‘sp_’?
How do you know if sql server is running on your local system?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
