Possible to edit a collection in SSIS

Question

I am trying to change a maintenance plan in SSIS to dynamically backup certain databases to certain places based on certain conditions... But it looks like the maintenance tasks use a collection for the selected databases list. As far as I can tell, I can't seem to manipulate a collection through an expression, nor can I seem to load up a variable to work as a collection.

Does anyone know a clever work around for this or do I just need to cut my loses and drop down into t-sql for it all?

Answer 1

SSIS has always been a source of irritation for me. Personally, I'd write the job up in TSQL, then schedule it using the SQL Server Agent. It feels lighter weight to me in the sense that if I need to edit the job, all I need to do is open up SQL Management Studio and make the change. Just my 2 cents.