Hi there,
I am desining a simle ETL package that has a main sequence container for which I set the Transaction Attribute to "Required". In this container, I have a data flow task followed by an EXECUTE SQL task and based on the results of that query, a simple ForEach Loop container (ie inside the sequence container there is a foreach container) that calls a stored procedure with the results from my SQL task so that I can call the stored procedure with proper parameters after all rows have been updated.
When the transaction attribute is on "Required" I systematically get an error on my ForEach container that says: "Error: 0xC00291EC at Update Path from Parents, Execute SQL Task: Failed to acquire connection ".NET - DataBase". Connection may not be configured correctly or you may not have the right permissions on this connection."
However, If I set it to "Supported", it works fine... I'm using Vista 32bits and SQL 2005/SSIS SP3.
If anybody knows how to get around this issue it would be greatly appreciated. It seems to be MSDTC related but since I'm not running WinServer I cannot configure my MSDTC beyong simply using the local one...
Thanks,
Greg
I am desining a simle ETL package that has a main sequence container for which I set the Transaction Attribute to "Required". In this container, I have a data flow task followed by an EXECUTE SQL task and based on the results of that query, a simple ForEach Loop container (ie inside the sequence container there is a foreach container) that calls a stored procedure with the results from my SQL task so that I can call the stored procedure with proper parameters after all rows have been updated.
When the transaction attribute is on "Required" I systematically get an error on my ForEach container that says: "Error: 0xC00291EC at Update Path from Parents, Execute SQL Task: Failed to acquire connection ".NET - DataBase". Connection may not be configured correctly or you may not have the right permissions on this connection."
However, If I set it to "Supported", it works fine... I'm using Vista 32bits and SQL 2005/SSIS SP3.
If anybody knows how to get around this issue it would be greatly appreciated. It seems to be MSDTC related but since I'm not running WinServer I cannot configure my MSDTC beyong simply using the local one...
Thanks,
Greg