Diffrence between DTS vs SSIS
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 are the differences between char and varchar in ms sql server?
What are indexers?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
select empid empname from employee What is the result for the about query?
syntax and example for bitmap index in sql???
What is t-sql script to take database offline – take database online.
What is ssl in sql server?
Will the writetext statement activate a trigger?
What language is sql server written in?
How to count the number of duplicate items in a table?
What is a schema in ms sql server 2005?
Why Master database is required?
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)