What is the difference between DTS and SSIS?
- 3 Answers
- 36369 Views
- Allianz, I also Faced
- E-Mail Answers
Answer Posted / ramesh
DTS--> Data Transformation Services
SSIS-->Sql Server Integration Services
in DTS:Message Boxes in activeX scripts
SSIS :Message Boxes In Script Tasks
In DTS:dynamic Properties+ActiveX scripts
SSIS :Configurations+PropertyExpressions
IN
DTS:no deploymentWizard
SSIS:deployment wizards are there
DTs:Limited Set of Transformations
SSIS:huge number of Transformations are available
DTS:ni BI Functionality
SSIS:complete BI Functionality
| Is This Answer Correct ? | 48 Yes | 11 No |
Post New Answer View All Answers
can a table be moved to different filegroup? : Sql server administration
What are the new features of sql server 2008 r2 reporting service?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to receive returning result from a query?
How many joins in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What are the lambda triggers?
What are the types of stored procedures in an sql server?
How many non clustered indexes there can be on table ?
List the types of recovery model available in sql server?
What is function of master database?
What are the differences between web role and worker role?
Which data type columns are the best candidates for full-text indexing?
What do you understand by recursive stored procedures?
