SSIS XML Connection Limitation

Hi,

I came accross this and spend a significant amount of time on it.  Thought I'd posit it for all.  I looks like 2005 SSIS has a limitation on the number of simultaneous transformations it can pull from an XML file using "XML source" as a dataflow.  I've got an XML / XSD that will load 20 tables.  I cannot put more than 13 into my data flow task.  If I do I get the error message below.  I've tried adding multiple OLE DB transformations to the same server/db and spreading my feeds accross the OLEDB destination connections and it still fails with the same error.  Despite the error pointing to the network I see no evidence of that.  I've tried everything and it consistently goes away when I have only 13 transformations and comes back as soon as I go up to 14.  I've not seen this documented as a limitation so I can only assume it's a bug.

BTW -- to get around the problem you can just add multiple data transfer tasks to the same SSIS project and that works fine.

Error: 0xC0202009 at Package, Connection manager "server1.conn1": An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.".

Error: 0xC020801C at Data Flow Task, OLE DB Destination 13 [12709]: The AcquireConnection method call to the connection manager "server1.conn1" failed with error code 0xC0202009.