Using import wizard to append to existing table

Question

Using import wizard to append to existing table

guerillaunit

SSCarpal Tunnel

Points: 4249
More actions
February 2, 2012 at 11:24 am

#254735

Hi there,
Is there a way to use the import wizard to append to an existing table? I can use the import wizard to bring tables in, but it always creates a new table. Is there a way to edit the dtsx file so that the imported table is appended to an another table?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jared SSC Guru Points: 61793 More actions · Answer 1

Absolutely, you just change the name of the table that it wants to import to. It usually crates its own, but you can select an existing table in the drop-down.

Jared
CE - Microsoft

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 2

You may also have to click Edit Mappings and choose one of the following....

Delete the existing data in the destination table and insert the new data OR

Append rows to the destination table

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

webmaster 95860 SSC Enthusiast Points: 106 More actions · Answer 3

hello,

In my case, the option to append to a table was greyed out, so I allowed for a new table to be created.

I then used an insert select statement to append to the existing table, from the imported table.

INSERT INTO categories_products (idProduct, idCategory)

SELECT idProduct, idCategory

from catprod_table

WHERE 1=1

This worked fine as a solution.

webmaster 95860 SSC Enthusiast Points: 106 More actions · Answer 4

I guess I also have a question, why is the option to append to an existing table in the Import Wizard grayed out?

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 5

webmaster 95860 (10/29/2014)
I guess I also have a question, why is the option to append to an existing table in the Import Wizard grayed out?

Where do you see this? As you can see in the screenshot, I can select an existing table just fine.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

rotimiawani Valued Member Points: 53 More actions · Answer 6

Select the destination table you want to append before you select Edit Mappings.