• It seems you're just getting started as a DBA administering SSIS and already looking for general advice on how best to approach it. So, that's good. At this point maybe you can start some good books, one as an introduction and one on design patterns.

    Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

    http://www.amazon.com/Knights-Microsoft-Integration-Services-24-Hour/dp/1118479580

    SQL Server Integration Services Design Patterns

    http://www.amazon.com/Server-Integration-Services-Design-Patterns/dp/1484200837/

    David Peter Hansen does some great conference presentations on SSIS performance, configuration, and operations from the perspective of a DBA.

    https://www.youtube.com/channel/UCIjPbfMxM8SWdms2kaofudw

    I myself am currently in the process of designing a large scale SSIS server to consolidate and standardize what our organization is currently using (about 30 legacy SSIS instances scattered about ranging from 2005 - 2012). Below is a dump of some of some MSDN and other source material related to configuring the network, hardware, and disk system to optimize the runtime environment of SSIS.

    http://thinknook.com/8-ways-to-optimize-your-ssis-package-2013-06-28/

    http://blogs.msdn.com/b/sqlcat/archive/2011/09/27/maximizing-sql-server-throughput-with-rss-tuning.aspx

    http://blogs.msdn.com/b/sqlcat/archive/2013/09/16/top-10-sql-server-integration-services-best-practices.aspx

    http://blogs.msdn.com/b/sqlperf/archive/2007/05/01/set-blobtempstoragepath-and-buffertempstoragepath-to-fast-drives.aspx

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho