Solved

SSIS import/export wizard

Posted on 2011-03-14
3
388 Views
Last Modified: 2012-05-11
Can I use the import/export wizard to append data to an already existing table? If so how? I am using SQL SERVER 2005.
0
Comment
Question by:qbjgqbjg
3 Comments
 
LVL 11

Accepted Solution

by:
rajvja earned 250 total points
Comment Utility
Yes you can do.
In the wizard, at the table list, click Edit Mappings. Choose append items to the table.
0
 
LVL 32

Assisted Solution

by:ewangoya
ewangoya earned 250 total points
Comment Utility

Yes you can, You do it exactly the same way you would import to a new table only you select the destination table
DataImport.PNG
0
 

Author Closing Comment

by:qbjgqbjg
Comment Utility
Thanks very much.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
format nvarchar field as mm/dd/yyyy 4 53
Get row count of current SQL query 8 34
Pivot Query Problem 9 30
SQL Server 2012 express 24 30
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now