Should I use SSIS to write programming logic?
To answer your question directly, if you know T-SQL and c# SSIS can do pretty much anything you need. My personal beef with it as a platform however stems from the fact the it tends to deal with data procedurally, instead of as a set. This is important because it's where RDMS's shine, so you're cutting off one of your best resources off at the knees. From my perspective, despite it's vast capabilities, it's more of a platform for people who aren't comfortable programming. 

To answer your question less directly, I found myself in a very similar situation 12 months ago. I found it useful to start by asking myself these two questions: 


What language am I most comfortable with?
And what environment am I most comfortable in?


After answering these questions, I chose to build my solution using those tools which enabled my skills.

In my case the answer was T-SQL and SSMS. Thus, I elected to remove the dependency on SSIS completely, and went the custom T-SQL/Agent route. In the end, I couldn't be happier with the decision. Maintaining &amp; debugging the solution is a simple task, since I'm so familiar with the language an environment.