SSIS - What is wrong with it
I recently visited a client that was achieving wonders
with DTS, I was there to give them pointers on SSIS. I spent a day gogin over
SSIS from the control flow to configrations.
A couple of things really got me was that SSIS is a new world that youhave to
learn and boy there is a lot to learn, SSIS has many ways of achieving the same
thing and many ways of doing it badly.
Whilist SSIS can do a lot, if your familiar with programming why venture away
from the activex script.
The interface sucks so why not write it all yourself.
I can't express how I felt after this day, the realisation of how difficult
SSIS is was overwhelming. Having used SSIS for 2 years I the number of features
that require special attention is huge.
SSIS is great for what it is designed for, but you need to all tricks to
really get the power out of it.
Jamie has responsding to similar annoyances on his blog http://blogs.conchango.com/jamiethomson/archive/2007/07/27/SSIS_3A00_-The-backlash-continues.aspx
-