How to copy data of one table from one server to another server using sql script..

Question

How to copy data of one table from one server to another server using sql script..
As i want to make a sproc for daily run,bcz i dont want to go through the right click import/export functinality.

-sql server 2008

Plz help me.

Thanks. .

Akkiraju Ivaturi · Answer

Create SSIS package. If you need any help give your specification and we should be able to help you out.

Hemant Srivastava · Answer

You may go with Import/Export option (as you said) and save that SSIS package for later use. Just Run that saved package whenever you need OR Create a job which run your saved SSIS package periodically.