SSIS 2005: "Append rows to the destination table" is greyed out. Why?

sql-server-2005 ssis import append dts
Pete Alvin picture Pete Alvin · Aug 6, 2010 · Viewed 14.4k times · Source

In SQL Server 2005, Import Data (SSIS), my desire is to import a text file and have it append to an existing table. The first time through the wizard on the Column Mappings step I swear the Append rows to the destination table radio button was enabled. But, now, it's disabled (grey) and even re-starting the wizard won't cause it to re-enable.

Is there some secret/magic I don't know about? How do I get that option to re-enable so that I can append (rather than Create destination table)?

Answer

Indy picture Indy · Aug 29, 2012

I know what you're missing... because I once missed it too!

From the screen, "Select Source Tables and Views",
there is a "destination" drop-down menu on the right side.

Select your table from this drop-down,
then click on the "Edit Mappings" button.

Now the append option will be enabled!

Related questions

"The selected data source is on remote computer" error when creating an SSIS job

I am in the process of developing an SSIS job on my workstation which a Data Flow Task open a comma delimited flat file on my local workstation and imports the data to a SQL server database on a remote …

Read More
Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

I have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv file into a table where all of the field types are NVARCHAR MAX. It works on my computer, but it …

Read More
How do I view the SSIS packages in SQL Server Management Studio?

Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go into job scheduler, either.

Read More