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 |
i need some interview questions on sql server developer plz any onee send some links.
event classes in sql server
explain different types of constraints? : Sql server database administration
Can we execute a stored procedure inside a trigger?
6 Answers BirlaSoft, CarrizalSoft Technologies, United Healthcare,
What is database replication?
Are semicolons required at the end of sql statements in sql server 2005?
What is a transact-sql statement batch in ms sql server?
How many databases Microsoft SQL server provides?
What is a job?
on line cluster can we make if yes tell me the procedure
How to write a query with a right outer join in ms sql server?
What happens if null values are involved in arithmetic operations?
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)