Exporting data with Stored Procedures

[GabeM]

I have a table on one SQL Server that receives data every day at differant times. I want to export the data from this table to another table in another SQL server. I figure I could use a Stored Procedure to run periodically and move the data. Is it possible to perform such a task with a Stored Procedure?

-GabeM

[ck9663]

Yes.

Couple of options.
1. Create SSIS to transfer the table.Make it a package. Create a scheduled job for it to execute in a pre-defined frequency.

2. Create a linked server. Create a stored proc that updates the table. Create a job that you can run in a defined frequency.

Either way, prepare some kind of data recovery.

---- CK

[GabeM]

I took your instructions and did as you recommended. It works great! Much Thanks!

-Gabe