SSIS Import/Export Wizard
Posted on 2011-03-14
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?