Solved

SSIS Import/Export Wizard

Posted on 2011-03-14
7
452 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

624 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