Im new to this and am having trouble with something that Im sure is simple.
I am trying to Append data from one table in a Sql Server to anouther table
in anouther Sql Server. I know how to export or Import a whole table but I
just want to append some data to an existing table. Both Servers are
registered in the Enterprise manager. Is this possible to do? Thank you in
advance for your help

Just use the Import/Export Wizard. You can select the option to transfer
data, and select the existing table.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"bob at zachys" <bobatzachys (AT) discussions (DOT) microsoft.com> wrote

Thank you I knew it was easy. What I was doing was selecting "Copy tables"
when I Should Have been selecting "Copy Objects and Data"

One last question if you dont mind. Once the DTS package is created is there
a way to rename the Connections to the Server name. This would make viewing
the DTS package in design easier to read. For example could I change
Connection1 to Bobs Sql and Connection2 to Sallys Sql.

Thank you once again I was not expecitng such a quick response

"Darren Green" wrote:

Actually that did not work, I must be missing something.

"bob at zachys" wrote:

You want "Copy tables and views"

Select the two tables. Click the ellipsis in the Transform column on that
pane of the Wizard. There are options for create table, delete data and
append data.

If you have an existing package that you saved, just open it and delete the
Exec SQL Task with any DELETE or CREATE TABLE.


To rename a connection, open the connection, click new connection and give
it a name etc. Check all settings, clock OK.

This will leave you with an orphan connection, it exits, but it will no be
shown on the design sheet. Clean them up like this-

Removing unwanted or orphan connections from a package
(http://www.sqldts.com/default.aspx?253)



"bob at zachys" <bobatzachys (AT) discussions (DOT) microsoft.com> wrote

Thank you for both answers. I knew it was easy, I was just missing something.

"Darren Green" wrote: