I want to select some fields from a table on one server and automatically create them in another table on another server
so SSIS package needs to do following
select field1, field2 from server1.table1
delete from server2.table2
insert into server2.table2
values field1, field2
what's the code / steps for doing this? I'm a bit lost! was thinking of a package in SSIS but is this more a stored procedure?