I got the same error when i tried to refresh SQL table from production to test using SSIS Data Flow Task. I worked around the problem by loading incremental data...

I encountered the same problem with our test environment and chose to reboot the server than trying to kill a system process. 
Than resolved the problem.