t sql: SQL Server automates updating a table only from one environment to another

I am looking for a best practice / option to update a table only from the Prod to Staging environment.

Technical details:

  1. The Source table is loaded daily with new data.
  2. The table at the destination should represent new data only when it is updated.

Some of the options I'm thinking:

  1. Replication (transactional)
  2. SSIS
  3. TSQL Script – SQL Agent Work

My first preferences would be to go with option 3. Will this be a good option? If so, can anyone guide me to a script?