title: SSIS: transaction during simultaneous moving of data
body: <p>I implemented SSIS package which moves data from Sql Server database to another one. This package has set of Data Flow Tasks which copy data simultaneously in different tables. Each Data Flow Task contain OLE DB datasource and Sql Server destination.</p>
  
  <p>Package worked fine until I decided to implement transaction. I found that it is not possible to just set <code>TransactionOption</code> to <code>Supported</code> on package level, because SSIS cannot handle transactions in multiple simultaneous processes. So, I decided to use this way:
  <a href="http://consultingblogs.emc.com/jamiethomson/archive/2005/08/20/SSIS-Nugget_3A00_-RetainSameConnection-property-of-the-OLE-DB-Connection-Manager.aspx" rel="nofollow">http://consultingblogs.emc.com/jamiethomson/archive/2005/08/20/SSIS-Nugget_3A00_-RetainSameConnection-property-of-the-OLE-DB-Connection-Manager.aspx</a>
  But now I have another problem. I have "<code>Unable to bulk copy data. You may need to run this package as an administrator</code>" errors. These errors occur in random places. For example if I ran package in the first time Data Flow Task named "Task A" can be executed correctly, but when I run package in the second time it can throw the error.</p>
  
  <p>How do I can implement transaction in my case? (Changing of package in order to perform execution of Data Flow tasks sequentially is not an option)</p>