How to make rsync to use relative path?

I think you don't want to use the --relative flag, as this creates subdirectories in the target location. Have you tried this?

From the man page:

 -R, --relative              use relative path names

What about passing rsync the --no-relative option?