I might be a little stoked so please forgive this post but I've had a submission accepted for the 2013 Pass Summit. In the "BI Platform Architecture, Development & Administration" track, I'll be delivering a talk titled "Type more, click less: Programmatically build SSIS packages."
Gratuitous browser abuse
Type more, click less: Programmatically build SSIS packages.
Why should you come to my session? Because you would love to automate some of the repetitive tasks you perform with SSIS.
You did know you didn't have to fire up BIDS/SSDT to make all your changes, right? In fact, did you know you can build complete packages without ever firing up BIDS? I wouldn't go that route unless I had a strong business case for doing so, but a little bit of up front work can yield an N% complete SSIS package.
After attending this session, I want you to know what your options are and when it makes sense to use one approach instead of the other.