I have a job that needs to execute roughly 30 tasks against a SQL database. Is there a way I can specify the connection to use at the job level rather than the individual task level? This is a job we will be copying for each customer, so would like to minimize the amount of time that will need to spent modifying the job each time a new copy is needed.

No, it is not possible. But I am not sure I see the advantage as every Task is Connection specific and a Job has not, in general, anything to do with a Connection.

---