SSIS Dataflow and distributed transaction

[knuxel]

Hi,

I have a SSIS-Package with a Dataflow-Task in a distributed transaction transferring data to a PostgreSQL-Server. Everything works fine, until I put more than 9 OLEDB-Source and Destinations in the Dataflow-Task.
Is there a maximum of 9?

Source: PGNP SE, Win 2008 Server, MSSQL-Server 2008 R2 64 Bit,
Destination: Windows 7 64 Bit, PostgreSQL 9.1 64 Bit

Thanks for help.
Kind regards,
Ralf Hundewadt

[knuxel]

I tried this with a MSSQL-Server as the destination and it works fine even with 12 OLEDB-Source and Destinations in the dataflow task.
Is there a limit in PGNP?

[Moderator]

Nope, there is no limit to the number of connections.