Hello! We have a big problem concerning transaction handling across domains in SSIS. Our local computer is on one domain and the database server is on another domain. The first object in the transaction has the property TransactionOption set to Required. All other objects in the same transaction have the property TransactionOption set to Supported. When executing the following error appears on the first object using database call: [Execute SQL Task] Error: Failed to acquire connection "METADATA". Connection may not be configured correctly or you may not have the right permissions on this connection. When change the property TransactionOption on the first object in the transaction to Supported, transaction works fine. If we work on a local computer (the database and the SSIS package on the same computer), transaction works fine. To solve the problem we have tried to change the DTC (Distributed Transaction Coordinator), we have read http://technet.microsoft.com/en-us/library/cc753620(WS.10).aspx and done the following: For the Local DTC on the server we have set (Tab) Security · Check Network DTC Access · Tried with both check and uncheck of Allow remote Client · Mutual Authentication Required We have tried different settings of the above. We have also done the same thing on the local computer. But the error remains as long as we use transaction handling. Does anyone know how to solve this problem? Best regards, Tina

Hello again! Forgot to write that we are Running SQL Server 2008 R2. BR Tina