Launch Full Pipeline One Time

edit

Friends, I need to take a doubt. I created a Pipeline to perform FULL loads once a day, but when starting the pipeline it is in an eternal loop, even after the creation of the full file. I put as an example the "PIPELINE FINISH" but when performing the first 30,000 records he finishes. Note: We must take into consideration that it has 1 million lines. What would be the solution when the 1 million line load finishes it stops?

• Query SQL -> SELECT * FROM PROD.dbo.PROP_PRODUTOS
• Incremental Mode -> NO
• Max Batch Size (Records) -> 30000