This post explain how you can include additional files in your package when packaging for the Development Fabric and for the cspkg you upload to the cloud. When using the Windows Azure Tools for Visual Studio, there are two times that you end up creating a Windows Azure Service Package:

-When you build and run on the Development Fabric -- this is a folder based package, extension is csx.  This is used by the Development Fabric.
-When you use the "Publish" feature -- this creates a .cspkg file which is a zipped and encrypted version of the csx built in (1).  This is what you upload to the Cloud.

Full Article