?
Solved

SSIS Import/Export Wizard

Posted on 2011-03-14
7
Medium Priority
?
466 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:
Ephraim Wangoya earned 668 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 1332 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 1332 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

864 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