Answer Posted / venkat
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 |
Post New Answer View All Answers
Can group by and orderby be used together?
List out the differences between global and local temp tables in sql server?
Define magic tables in sql server?
Which table keeps the locking information?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What are the 10 characteristics of data quality?
Define Joins?
What is a result set object returned by odbc_exec()?
What is sql stored procedure?
whats new about truncate in sql server 2008?
Explain about the command-line tool SQLCMD?
What is the datatype of rowid?
What is a print index?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
How to send a ssrs report from ssis?