You can try changing the location for the buffer files by setting the BLOBTempStoragePath and BufferTempStoragePath properties of your data flow task. Let me know if that helps. And if not, if you could
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.