Three quick questions:
1). Can you load the original 'raw' sample (.wav) into Rapture (Load Multisample dialog)?
2). Have you checked the .sfz file for extra spaces, naming errors, etc.?
(You can copy your .sfz file text and paste it into a reply here.)
3). Are you getting any error popups (sfzlog)?
(You can copy the error log contents and paste them into a reply here.)
EDIT:
I see that you've had some measure of success. The end results will vary widely; depending on the original sample source, the length of the file, etc. If this first experiment sounds like it has a HP / BP filter on it, look to the frequency distribution of the sample source.
Rapture is going to interpolate everything in the source sample, and 'reduce' it down to fit an oscillator's characteristics. A .wav file of several seconds will get 'squeezed' into the space of a few thousand individual samples.
I don't know what you've used as a source file, but you can try some simpler .wav files, and build up to more complex ones. Perhaps some single notes from a synth, or some drum hits. You have to try a few dozens examples before you can get a 'feel' of what to expect in the results of a "forced oscillator".