Thanks Jack/whereisSQL for the replies. Thats why I used the term "generally" as I wanted to know how the things are done MOSTLY in the organizations. As i don't have any experience and going through the learning curve, I have no idea on that.

I understand that if you are joining a team which already has entire setup done, then it makes your work easy as you have to work accordingly. But say there is new requirement coming up in your project and everything has to be worked from scratch, then which should be ideal one (from that perspective).

Though I got the idea from the discussion here that deploying through deployment utility to the file system seems one good OPTION.

Phil, thanks for providing your view on SSIS 2012. I am currently learning on SSIS 2008, so will learn that as a part of upgrading to SSIS 2012.

Though it may sound different and difficult, are there any case studies of SSIS implementation ? (it may be foolish question again but I want to learn as how practically the things are wokring in real time scenario )