SSIS Dataflow and distributed transaction

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

SSIS Dataflow and distributed transaction

Postby knuxel » Mon Oct 29, 2012 10:18 am

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
 
Posts: 6
Joined: Wed Oct 10, 2012 6:34 am

Re: SSIS Dataflow and distributed transaction

Postby knuxel » Tue Oct 30, 2012 6:15 am

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?
knuxel
 
Posts: 6
Joined: Wed Oct 10, 2012 6:34 am

Re: SSIS Dataflow and distributed transaction

Postby Moderator » Thu Nov 15, 2012 5:39 pm

Nope, there is no limit to the number of connections. :roll:
User avatar
Moderator
Site Admin
 
Posts: 293
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests