The startup account is set to "Local System Account." The files are being stored in a folder on the same server. I made sure that "NETWORK SERVICE" has full permissions on this folder.

Again, the package runs successfully if I launch it from Query Analyzer; it just hangs when I try to run it from within the stored procedure or trigger it from the web app.