not sure about changing it, but you could always use Kpackage to find the dependencies, then find the RPM on the CD using the grep command, and rpm -Uvh package.rpm to install them.
Also, just a quick question, when you are changing the source in kpackage, are you logged in as root? I would imagine that would be a root only privilage. What error are you getting when you change it also?