Append existing output option overwrites SQL table

Hi all,

I have an existing SQL table in MS SQL Server. What I would like to do is to take an Excel file, which has the same field as the mentioned tabled, and just append it's fields to the table (as Union tool would do).

I do that by selecting 'Append existing' in output options. However, what it does, it just overwrites the existing table and all the old records are gone, only new from the Excel are in the final result. Do you know what might be the issue? Or am I using wrong output option? Thank you in advance.

Output

Accepted answers

IraWatt

@Inactive User I would also try using the data Stream In and Write Data In tools:

See if you have more success use them.

All comments

IraWatt

Hey @Inactive User,

Not sure what the issue is. I just tried Append existing and it worked fine.

Do you have any warning messages in the results window? I would also check your connection string see if it has any settings there?

IraWatt

@Inactive User I would also try using the data Stream In and Write Data In tools:

See if you have more success use them.

hannah_malek

@IraWatt - which creation mode did you use in the data stream in tool? I was just replicating this process and wondering which configuration option you set as none of them seemed appropriate for appending to an existing table in a database. Thank you!

Data Stream In.png

IraWatt

Hi @hannah_malek, I would have created a temporary table, then appended that table. I would have chose temporary as the table would be deleted after the end of the session meaning we are just have the combined table at the end.

apathetichell

@hannah_malek datastream in shows different options depending upon the underlying DB type it is connecting to. With no Db selected you will not be able to see append - only create temporary/create new/overwrite (drop).

hannah_malek

Thank you @IraWatt and @apathetichell for your assistance!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703