• To start with, turn on package logging to see where exactly it is getting stuck. BIDS is 32 bit, so you may be having a problem with the job running in the 64 bit runtime. You should find another program files folder with the 32 bit DTExec runtime in it - this is a good way to determine if you have a 64 bit specific problem.