Good to know it helped and you have something automated 🙂

Not sure if this is good question to ask but still; are you running SP from management studio and SSIS package on same database or on different copies of databases?

The...

Your code should be like below:

parameters[0].DefaultValues = new string[] {"My_DB_Name"};

rs.SetItemParameters(report, parameters);

You need to create an array of ItemParameter and pass it to the function. Below is the sample code:

ItemParameter[] param = new ItemParameter[1];

param[0] = new ItemParameter();

param[0].Name = "parameter1"; ...

SSIS does not support multiple instances on a machine. Having said that, for 2012 SSIS packages have a new deployment model and you can see a new item named as...