Is there a limit to the size of a production file being generated with a variable data file?

There is not a single number as there are variable conditions that will have an affect. For example, large vdp runs (data merging from an uploaded xls or csv file) can sometimes fail, especially when there are lots of image fields and/or the master PDF is huge and/or the output is being imposed.