[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

SSIS import/export wizard

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
qbjgqbjg
Asked:
qbjgqbjg
2 Solutions
 
rajvjaCommented:
Yes you can do.
In the wizard, at the table list, click Edit Mappings. Choose append items to the table.
0
 
Ephraim WangoyaCommented:

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
 
qbjgqbjgConsultantAuthor Commented:
Thanks very much.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now