SSIS Import/Export Wizard

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?
qbjgqbjgConsultantAsked:
Who is Participating?
 
Ephraim WangoyaCommented:

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
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> 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
 
qbjgqbjgConsultantAuthor Commented:
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
qbjgqbjgConsultantAuthor Commented:
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
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Have you applied SP4 for SQL Server 2005. If not, then apply it and try after that once..
0
 
qbjgqbjgConsultantAuthor Commented:
I am checking on it.
0
 
qbjgqbjgConsultantAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.