Jun 30, 2011 · Free source code and tutorials for Software developers and Architects.; Updated: 30 Jun 2011 I am using sql server 2008 R2 x64 CU2. I have a data flow in a very simple SSIS Package. within it, I have one OLE DB data source that points to a remote server (Server A), a multicast component and two OLE DB data destination components. the destinations are two tables in the same database in a remote server (Server B). If i make transaction support required for the dataflow i get the ... © 2020 Microsoft. All rights reserved. Newsletter | Contact Us | Privacy Statement | Terms of Use | Trademarks | Contact Us | Privacy Statement | Terms of Use ...