This is not a permission issue. Because from 1 year job is running, and we did not have any problem. But from two days job has started failing because the records are more.

we have 28 Gb free space in C drive. we job is running, all 28 Gb will be reserverd by the job. After completing the job it will release the reserved space.

My concern is that, we have one source and one destination. Is there any alternative option apart from Lookup transformation, because Lookup will take all the drive space and then start copying the data.

I want something like which will not overloaded in both source and destination server and we can copy data easily through job.

Thanks