I used the export/import wizard to create a package that uses a view to load a text file with fixed width format. The view has ~75k rows and takes 15 seconds to fully load in enterprise manager (sql server 2005). The text file is located on the same server. For some reason I get stuck on "executing" (have waited 20+ minutes). I have created a different package with the import/export wizard on a different table (same method) with ~1000 rows and it worked instantly.
Not sure how to troubleshoot this problem?