Does the Database Partitions task support transactions?
Yes, it does.
The task is using the connection object provided by the connection manager (AcquireConnection). It doesn't instantiate a new connection object based on a connection string. We went through all this hassle to make sure we DO support transactions properly.