Solved

SSIS Import/Export Wizard

Posted on 2011-03-14
7
435 Views
Last Modified: 2012-05-11
I want to use SSIS Import/Export Wizard to append data to an already existing table. I tried the suggestions in my original question, however, When I am at the Destination selection screen it does not give me a chance to choose a table, only a database. It automatically gives the table the same name as the source. On the Edit Mappings there is an option to append, but it is greyed out. What do I need to do to make this work?
0
Comment
Question by:qbjgqbjg
  • 4
  • 2
7 Comments
 
LVL 32

Accepted Solution

by:
ewangoya earned 167 total points
ID: 35131838

You first have to select the database you are importing data to first, then select the destinationation tables as shown here.

If Append Data is grayed out, it means the field types in your tables do not march
SelectTables.PNG
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 333 total points
ID: 35135377
>> When I am at the Destination selection screen it does not give me a chance to choose a table, only a database.

First, Make sure that the login under which you are trying have Permissions to connect to that database and have SELECT/ INSERT privileges on the tables involved to get it work..
0
 

Author Comment

by:qbjgqbjg
ID: 35137821
OK, I will check on the permissiuns. I created that database, if that matters. It let me create the table with the wizard as a new table, copying data to it. Automatically named it the same as the Source.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:qbjgqbjg
ID: 35137918
I tried a different database, where I have used insert (in SQL) but it does the same thing. Would this be because my source is Excel?
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 333 total points
ID: 35143985
Have you applied SP4 for SQL Server 2005. If not, then apply it and try after that once..
0
 

Author Comment

by:qbjgqbjg
ID: 35149168
I am checking on it.
0
 

Author Closing Comment

by:qbjgqbjg
ID: 35156826
Thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
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…

706 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

20 Experts available now in Live!

Get 1:1 Help Now