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 are various aggregate functions that are available?
What is the command dbcc checkdb used for?
What is difference between aggregate and analytic function?
How to transfer a table from one schema to another?
How to drop an existing user defined function in ms sql server?
Is sql server is free?
Can a table have 2 foreign keys?
Difference between LEN() and DATALENGTH() in sql server ?
What are commonly used odbc functions in php?
Do you know exporting and importing utility?
Explain for xml explicit mode?
What is difference between delete and truncate commands?
Tell me what is a linked server?
How to transfer data from a cursor to variables with a "fetch" statement?
What is the openxml statement in sql server?