It is possible to edit the collection in SSIS
I'm trying to change the maintenance plan in SSIS to dynamically back up specific databases to specific locations based on specific conditions ... But it looks like the maintenance tasks are using a collection for a selected list of databases. As far as I can tell, I cannot manipulate the collection through an expression, and I cannot load a variable to work as a collection.
Does anyone know a clever job for this or do I just need to cut my losses and go down to t-sql for all this?
a source to share
SSIS has always been a source of annoyance to me. Personally, I write a job in TSQL and then schedule it using SQL Server Agent. It feels lighter to me in the sense that if I need to edit an assignment, all I have to do is open SQL Management Studio and make changes. Just my 2 cents.
a source to share