Package Transaction With OLE DB Transformation Transactions

Greetings,

I have a requirement from the client that specifies to rollback every insert/update that happenned in the package if any task (control or data flow) fails.

I'm certain the SSIS package-level transactions take care of this, however, in this package, there is an OLE DB Transformation that executes a stored procedure which has a transaction in itself.

so to draw a quick picture...
Package
{

Transaction1
{

Data Flow
{

OLE DB Transformation
{

Stored Procedure
{

Transaction2
{
}
}
}
}
}
}

Here's my question:
What would happen if an error occured in the stored procedure (Transaction2)?

Does it behave like SQL Server 2005 where, given a scenario of nested transactions, the innermost transaction is comitted and the outermost transaction is rolled back?


I'm hoping that if the stored procedure decides to rollback Transaction 2 via error handling or if an SQL error occurs that I can rollback Transaction 2 and log an entry in the audit log.