Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is row_number function?
What is data source in connection string?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What are page splits?
Can we use custom code in ssrs?
When is the use of update_statistics command?
What stored by the model?
What is shared lock?
Define normalisation?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is optimization and its types?
Does an index slow down updates on indexed columns?
How to backup SQL Server Reporting Services ?
What is cross join in sql server joins?
