Ok, I found the "delay validation" option and set it to TRUE! Whooo hooo... I was able to get it to execute from within BIDS after validating it.