Data Flow execution hangs with no error

I have a SSIS (CTP June 2005) package with several data flow tasks. One data flow has 2 OLEDB data sources which are then unioned together, followed by a conditional split, then a derived column transformation, which feeds into an OLEDB destination. When I run the package, this particular data flow seems to run fine and then just stops. There are no errors and the records counts don't move. I've used data viewers to look at the data and it seems fine. I've switched the OLEDB destination with a flat file and execution runs fine, then switched back to OLEDB and it hangs again (over and over). There's nothing unusual about the OLEDB destination, and all the other OLEDB destinations work fine. It also seems to hang on the same destination row number count, but again that row has been verified as valid. In fact, I dropped the DB table and recreated it with no constraints and all fields nullable, but the problem persists. Help?
[947 byte] By [GordonMoll] at [2007-12-17]
# 1
My guess is that your destination also happens to be a source. The OLEDB destination defaults to a table lock and can block out reads from the same table...
JonathanHseu at 2007-10-6 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 2
You are correct, the OLEDB destination table is in the From clause in each OLEDB source. So, I unchecked the table lock in the destination and it still hangs in the same place. FYI, the table is empty when both of the source tasks execute and is loaded by the destination task. Is tehre anything else I can try?
GordonMoll at 2007-10-6 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 3
My guess is that SQL Server is escalating page locks to a table lock. In general, you can't have a destination table that is the same as the source table if it is on the same server and in the same dataflow task (or even in multiple dataflows if they are run in parallel) because of locking (and lock escalation) in the database.

Thanks,
Matt

MattDavid at 2007-10-6 > top of Msdn Tech,SQL Server,SQL Server Integration Services...

SQL Server

Site Classified