<div>
I would try to use the import/export wizard for that and at the end make sure to mark the option 'save package'. Once it is saved, you can create a SQL Server job to run that SSIS package on a regular base. The wizard will actually create the SSIS package for you.<br />
<br />
Hope this helps ...
</div>


I would try to use the import/export wizard for that and at the end make sure to mark the option 'save package'. Once it is saved, you can create a SQL Server job to run that SSIS package on a regular base. The wizard will actually create the SSIS package for you.

Hope this helps ...

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am just starting to use Integration Services.<br />
<br />
I want to move three tables from a database on one sql server and copy them to another sql server.<br />
<br />
The package is to be run every month.<br />
<br />
How would I go about setting this up?<br />
<br />
Thanks<br />
<br />

</div>
</div>


Hi,

I am just starting to use Integration Services.

I want to move three tables from a database on one sql server and copy them to another sql server.

The package is to be run every month.

How would I go about setting this up?

Thanks



Copying 3 tabes from one server to another

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.