1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. SSIS Dataflow and distributed transaction

SSIS Dataflow and distributed transaction

  • knuxel
  • Topic Author
  • Visitor
  • Visitor
9 years 6 months ago #9814 by knuxel
SSIS Dataflow and distributed transaction was created by 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

Please Log in or Create an account to join the conversation.

  • knuxel
  • Topic Author
  • Visitor
  • Visitor
9 years 6 months ago #9815 by knuxel
Replied by knuxel on topic Re: SSIS Dataflow and distributed transaction
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?

Please Log in or Create an account to join the conversation.

More
9 years 6 months ago #9820 by Moderator
Replied by Moderator on topic Re: SSIS Dataflow and distributed transaction
Nope, there is no limit to the number of connections. :rolleyes:

Please Log in or Create an account to join the conversation.

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. SSIS Dataflow and distributed transaction
Time to create page: 0.059 seconds
Powered by Kunena Forum