I am dealing with a similar situation. At the moment, we are using the visual studio plugin which you can download via the deployment manager website. Developers then can right click the website they want to deploy in visual studio and click "publish for deployment..."
The more advanced way is to have the package created as part of a continuous integration build process. For this you will need a TFS build server and to create a build template for each project in TFS. You would then need to add a step to the build template which calls the RgPublish.exe program to package the output of your build process.
If you are not familiar with MSBuild in TFS, then you will need to get that working first if going the continuous integration route.
The documentation for using RgPublish.exe is available here:
http://documentation.red-gate.com/displ ... ublish.exe