After digging a bit more, I found this video youtube.com/watch?v=INgsOSJefdM. It has worked for me. I'm not sure if it will poses any issues running it on a monthly basis, but it worked for my current pull. Basically the idea is to first create a global temp table in the source server, dump the results into the global temp table, and use a data flow task to pull from the global temp table and bring it in to the destination. However, you need to set your settings for DelayDataValidation to true AND RetainSameConnection to true.