Problem creating a transaction in an SSIS package
I solved the problem.  I had read in several places that DTC needs to be started on the source machine as well as the destination.  So in my place my workstation as well as the server the instance is on.

Once I had turned MSDTC on I received a new error:

Information: 0x4001100A at CATS-Package: Starting distributed transaction for this container.
Error: 0xC001402C at CATS-Package, Connection manager "connectionName": The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D024 "The transaction manager has disabled its support for remote/network transactions.".
Error: 0xC0202009 at CATS-Package, Connection manager "connectionName": SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x8004D024.
Error: 0xC00291EC at Execute SQL Task - Max Product ID, Execute SQL Task: Failed to acquire connection "connectionName". Connection may not be configured correctly or you may not have the right permissions on this connection.


With the important part being The transaction manager has disabled its support for remote/network transactions. 

Once there I did additional research and finally realized I hadn't configured my local DTC to allow Network Access etc.  Once I configured it to allow Network DTC Access, Allow Remote Connections and Allow Output connections everything worked smoothly.



I'm not sure this is the minimum permissions required for the local connection but it appears to be.