Package Hanging On OLE DB Command With Large Result Sets

I have an SSIS package (SQL 2005 SP2 and Visual Studio SP1) that does the following:



OLE DB Source --> Conditional Split --> OLE DB Command #1 --> OLE DB Command #2



The source reads from database A. Each row is variable-width and up to several KB wide, including two ntext columns.



Command #1 executes a stored proc in db A, using a bunch of inputs and two output parameters.



Cmd #2 executes an update in db B, using the two output params from cmd #1 as inputs.



When the rowset size is small, around 500, everything works fine.



However, when the rowset size is larger, around 5000, SSIS hangs when trying to execute cmd #2. The profiler shows that none of the cmd #2 updates are ever executed. No error messages are produced, and the connection never times out -- it just hangs forever.



If I replace the cmd #2 updates with a simple select, everything works fine. If I replace it with a stored proc that does an update, it hangs.



The work-around I came up with was to create a new table in db B, and do inserts into the table, but unless I'm missing something, this still seems like a bug...