Hi.
I'm working on 'bigger' SSIS vs DTS comparison, but actually don't know where to start. Can someone experienced give me some clues/resources about that I was able to find only some parts, short texts, that SSIS is about 7 times faster, etc. But I need to make some tests and analisis as well. Any help would be appreciated.
Thanks in advance,
Michal
SSIS vs DTS - what to compare?
Abraham Sultan
Thank you vary much for your help. I was able now to find some articles, mostly short, but still helpful. If you would have to choose 8 enchancements (4 functional and 4 performance) from those 500 ;) what would it be I have some tips but I'd like to know what more experienced users say.
Thanks in advance for help,
Michal
Sharique A.Farooqui
http://blogs.conchango.com/jamiethomson/archive/2005/04/20/1319.aspx
and
http://www.scalabilityexperts.com/default.asp action=article&ID=167
Haven't done any tests. I don't need to. Compiled code will always massively outperform the painfully slow ActiveX script.
-Jamie
aliali
Functional:
Perf:
There's not much to talk about on perf except to say that the data-flow task is a phonomenal piece of technology and will run all over the DTS data-pump in high-volume/high-complexity situations.
That list would probably be completely different if I wrote it yesterday - there's just so much to talk about
-Jamie
Juergen Bayer
Phew, where to start You could write a 500-page opus on that subject matter.
What specifically are you looking to compare Functionality, Performance, or something else
Perhaps this might help in regards to functionality : http://blogs.conchango.com/jamiethomson/archive/2005/05/09/1396.aspx
Or in regards to perf : http://blogs.conchango.com/jamiethomson/archive/2005/10/21/2289.aspx
I have a series of upcoming blog posts that expands on what I've said in the first link.
HTH
-Jamie
Artybartfast
I've produced a several SSIS packages (keeping in mind the original ones done by sql2k) and frankly its behaviours are very similar.
They are simply ETL packages and taking almost the same time in both platforms.
Neftali Reyes
Thanks Jamie for your very helpful post.
If you find a moment, could you write some more (few sentences) on those two points
- SSIS Performance counters
- Compiled code rather than script (did you make tests could you share with some data )
It's really much to talk about, still have new ideas but as a rookie I will listen to experts ;)
Michal
Sean John2005
Hi, thanks for the comments. Well it certainly depends on what exactly your doing and for some operations there may be no functional difference. However for some users that fact that the new SSIS desinger is Visual Studio is a huge benefit as they are familiar with it from other work.
SSIS has seperated out 'work flow' and 'dataflow' in a more detailed manner allowing users to have more complex packages. DTS could certainly do a lot, however almost anything that was complex required script and now you can have very complex packges without ever writing script. Not to mention there is a full API underneath that allows you, from code, to create SSIS packages on the fly. Users have created their own web interfaces where thier front line users make some choices, spin dials, and push buttons, and then their app behind the scenes creates and executes, on the fly the SSIS package, from scratch.
Again, it does all depend on what someone is trying to accomplish.
ssdfsdfsdfsdfsdf
Yes, Jamie underscores well how different they are, one reason the names changed. I always like to say DTS was a utility that was slowly trying to become an application and with SSIS We started over and created a platform which is very extensible. There is a good set of out of the box objects (transforms, tasks, sources...) but you can create your own as well as programmatically build/modify packages. Jamies sums are very good ones. I would add one comment to help set expectations. Because SSIS is a platform what users sometimes find is the very easy things from DTS require a little more effort in SSIS but the trade off is you can do so much more in SSIS. Its a classic trade off of moving from a very wizard/automagic like environment to one where the focus was on building the infrastructure to allow you to do a lot more.
Hope that helps.