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 the difference between functions and scalar functions?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How efficient you are in oracle and SQL server?
What are trace flags and mention a few common trace flags used with sql server?
how to take backup bcp out for a column in table in sql server?
what are different types of backups available in sql server? : Sql server database administration
Is sql server free?
How to provide default values to function parameters?
What are “lost updates”?
What is the sql case statement used for?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is 5nf in normalization form?
What are the different types of columns types constraints in the sql server?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Explain what is public role in sql server?