I have built a publication in which we have built our own filtered views that the replication views use to pull data for our customers. Each customer gets his own data based on a single view that uses the suser_name() operation. When I use a standard snapshot and let the customers replicate from their machines, everything works fine. I have now tried to convert it over to use Dynamic Snapshots (Because the initial load was taking over 2 hours). I have ran the Dynamic Snapshot, but for some reason, it is not loading any data at all. All my bcp files have no data in them at all. Building it for the first time still takes over 2 hours (Which is fine as long as the initial load to the customer is faster), but I'm not getting any data at all.
I can offer up more detail if needed, but if anyone has any recommendations on this, I would appreciate it.