I had the same problem and I had to change the OLE DB destination ValidateExternalMetadata as suggested above. That solved the hanging problem. I also found that before...