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 query cost in sql server?
What is ems sql management studio? : sql server management studio
What is dynamic cursor in SQL SERVER?
What is the cpu pressure?
Explain following error properties?
When is the use of update_statistics command?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What are the different types of lock modes in sql server 2000?
Where do we use trace frag?
What is bcnf normalization form?
What is sql server management studio? : sql server management studio
Explain datetime2 data type in sal server 2008?
What is store procedure? How do they work? When do you use?
Show Practically Sql Server Views are updatable?
Explain the steps needed to create a scheduled job?
