I had one server with ip address like 198.176.0.12 and other with 198.176.1.23
I want to tranfer 6 table data from first server to second server through
package.
and both server had same sechema.
and i want before my package execute all the deta in the table of second
server should delete from the same pacakge.
How can i do it with meta deta packages or local pacakge

--
waiting for solution
from
Sufian

How the package is stored is not really an issue because a package is
pretty much a package wherever it is.

To delete the data in the destination before transferring?

Is that only the equivalent data you are transferring from the Source?
Is that all data?


You can accomplish this in a number of ways but here is two.

In the Transfer Objects task there is the option to replace destination
data first

You could use an ExecuteSQL task pointing to the destination connection
and do it that way.


Allan

"Mohd Sufian" <sufian (AT) aeroflex (DOT) co.th> wrote

Dear,
Thanx for the first answer how to delete from destination table but still my
problem.
I want to transfer data from 6 tables of first server to the 6 tables of
second served and i want to do it at a time.

do i have to do it with meta deta or is it can be done with local pacakage

thanx
sufian

"Allan Mitchell" wrote:

Just create a package to transfer the data. You can schedule it using
SQL Server Agent. You can execute the package from wherever you store
it. Have a look at DTSRUNUI for the cmdline syntax

Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)




"Mohd Sufian" <sufian (AT) aeroflex (DOT) co.th> wrote

Thanx , it solved my problem

"Allan Mitchell" wrote: